Questions tagged [worksheet-function]
Questions about using in-cell functions/formulas in spreadsheet software.
2,598
questions with no upvoted or accepted answers
-4
votes
1
answer
84
views
How to sum in Excel with month logic?
Mentione in the picture, I have 2 Excel sheets, Sheet 1 with ID Q1 and Z1, and NAME in column and month in rows. And in Sheet 2, I have ID Q1 and Z1 with the amount in month column.
My requirement ...
-4
votes
1
answer
167
views
Based on input value, place an associated object in another cell
I have a collection of predefined input codes. When an input code is entered in an input cell, I want to automatically post an associated object in an output cell. For example, using the code table ...
-5
votes
2
answers
115
views
How can this VBA be adjusted
As per your request The original post is here How do I hide rows based on a cell value
I have received the VBA below from Ted D, following a question I posted here.
Unfortunately it is not working ...