Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to see columns from which values were not returned by HLOOKUP functions?
Hello
How to see columns from which values were not returned (or were returned) by HLOOKUP functions on a worksheet? All formulas contain only HLOOKUP functions. The table_array s include all columns on the worksheet. |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to see columns from which values were not returned by HLOOKUP functions?
If I'm interpreting your question correctly, one solution would be to
run a Histogram of the formula results. That would show how many occurrences of each result were obtained. If you're unfamiliar with the Histogram function, you need to have installed the Analysis Toolpak Add-in (go to Tools/Add-ins and click on Analysis Toolpak), then go to Tools/Data Analysis and select Histogram from the menu of options. The in-built Help files explain further. hth ScottO "Dmitry Kopnichev" wrote in message ... | Hello | How to see columns from which values were not returned (or were returned) by | HLOOKUP functions on a worksheet? All formulas contain only HLOOKUP | functions. The table_array s include all columns on the worksheet. | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
HLookup and If Functions | Excel Discussion (Misc queries) | |||
How do I sum values returned from functions? | Excel Worksheet Functions | |||
How to see columns from which values were not returned by HLOOKUP functions? | Excel Worksheet Functions | |||
Multiple "IF" functions one one cell returned from different cells | New Users to Excel |