| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
find instances & report neighboring values
I am attempting to sub total amounts by month for a fairly large number
of items. I would like to have excel find all instances on one date (Oct-05 or Jan-06 for example) and report all of the values in the cell neighboring each (ex, if I am adding the Oct-05 values, I want it to find the Oct-05 in d-4 and d-8 and report the value for e-4 and e-8). Once the values are reported, I need the values added . I don't care to see each value but I do need the total to be seen. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
| How to find the minimum value in a database with multiple values . | Excel Discussion (Misc queries) | |||
| in excel, how do I find which values doesn't have a pair? | Excel Discussion (Misc queries) | |||
| How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
| To find different values in Col B corresp. to repeated vaues in c | Excel Worksheet Functions | |||
Threaded Mode
