Look in to the attached file there is formula in cell Z138 formula result is 357 , that reflect by cell Q138 that is correct, that is easy to understand that result came from cell Q138 but another result just below the cell Z138 it means look in cell Z139 that result 901 reflected from which cells, what is the source of that result, that formula depends on which cells
Z139 is total of all values in column Q when date in column O matches date in cell O139 [5/10/2018].
1. Click on the * Add Reputation if you think this helped you
2. Mark your thread as SOLVED when question is resolved
Modytrane
IF you look down column O, the date 5/10/2018 shows up in Rows 139, 180, 203 etc
But cell Q139 value is 2 and cell Q180 value is 169 and cell Q203 value is 120 sum of that is only 291 we need more 610 to become total of 901 so what is the source of this 610 value
look at rows 1406 and 1407
This time my problem is solved, but i am curious if possible how can highlight that cells with colour that depends on particular formula,
tell me if it is possible
If you highlight the cells [source] referenced in the formula, you'd have to look all the way down to find them.
Instead I have inserted formulas to list Row numbers of cells that the formula is adding up.
see attached. I have included formulas in Rows 138, 139.
Here's a typical formula:
It's an array formula so you need to enter it with ctrl+shft+ent.HTML Code:
Thanks now my problem completly solved
Last edited by keshavtale; 10-03-2019 at 09:25 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks