Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Translate in English please...
I have this excel form that gathers data from an external source and
references other columns in other sheets. I do not understand what this is trying to accomplish =IF(ROWS($1:1)<=COUNTIF(J$2:J$645,'Budget Input'!B$5),INDEX(K$2:K$645,SMALL(IF(J$2:J$645='Bu dget Input'!B$5,ROW(K$2:K$645)-ROW(K$2)+1),ROWS($1:1))),"") I think it says for a row (with $1 being variable) Count the column J and index them against column K, if a value in J equals Budget Input worksheet cell B5, then match the existing rows in K - ...here is where I am lost... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To Translate English to Arabic | Excel Discussion (Misc queries) | |||
Translate any english number into English word | Excel Discussion (Misc queries) | |||
How can I translate chinese text to english | Excel Discussion (Misc queries) | |||
Translate formula to english | Excel Discussion (Misc queries) | |||
translate function into english, anyone? | Excel Worksheet Functions |