| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
show comparison variance
I have wo numbers in Column A and E. I need to see what is in E that is not
in A and show the value for that result that is in column F in column I. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
show comparison variance
Play with this to suit your needs:
=IF(COUNTIF(A:A,E1),"ok","Missing") best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Hilton" wrote in message ... I have wo numbers in Column A and E. I need to see what is in E that is not in A and show the value for that result that is in column F in column I. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show Variance between 2 lines in Graph | Charts and Charting in Excel | |||
| Variance | Excel Discussion (Misc queries) | |||
| variance % | Excel Worksheet Functions | |||
| Pivot Tables - Variance and Variance % | Excel Discussion (Misc queries) | |||
| Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
![Hilton[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
