Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find in multiple sheet...
I would want with a macro use the sheet STATISTICA similar a pivot (but
repeat i dont want a pivot). Bsed on column H and column D of GAF, scanning in all cells of columns H and if is found a value present in one sheet CORPORTAE, RETAIL_POE, PUBB_AMM, LARGE_COR, SCARTI, (have the same range for all sheet G2:G500) add 1 in cell refred column D of GAF and column A of STATISTICA fill the cell in STATISTICA based column D... Example: cell H2 in GAF contain 78 this value is present only in sheet RETAIL_POE in range G2:G500 put 1 in C25 of STATISTICA because in A25 is present 4549... cell H3 in GAF contain 78 this value is present only in sheet RETAIL_POE in range G2:G500 put 1 in C31 of STATISTICA because in A31 is present 4561... cell H4 in GAF contain "" put 1 in G25 of STATISTICA because in A25 is present 4549... cell H5 in GAF contain 78 this value is present only in sheet RETAIL_POE in range G2:G500 put 1 in C30 of STATISTICA because in A30 is present 4558... ......... cell H51 in GAF contain 11 this value is present only in sheet CORPORATE in range G2:G500 put 1 in B2 of STATISTICA because in A2 is present 4500... naturally if the value in H of GAF is found for many matching, ad +1 the the old value stored cells of STATISTICA Hope i am clear... here my file: http://www.mytempdir.com/991542 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find a Match in Multiple Places & Return Multiple Values | Excel Worksheet Functions | |||
lookup single value in one sheet, return multiple results from theother sheet | Excel Worksheet Functions | |||
How can I find multiple items on a sheet?? | Excel Discussion (Misc queries) | |||
INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions | |||
how to find and copy values on sheet 2, based on a list on sheet 1 | Excel Programming |