| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find difference between 2 cells if critera in a 3rd cell is met
How would I find the difference between two cells depending on what is in a
third cell? For example, in column G1 I want to show the difference E1 and whichever cell in column F contains the number 1. I was thinking something along the lines of using SUMPRODUCT to find the row with the #1 and then somehow subtracting G1 from the number column E that match the row where the number 1 was found. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA to find difference in cell locations | Excel Discussion (Misc queries) | |||
| Add cells based on critera | Excel Discussion (Misc queries) | |||
| Try to find the difference by percentage between 2 cell totals | New Users to Excel | |||
| change font color of cell based on critera | Excel Worksheet Functions | |||
Threaded Mode
