Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I FEEL AS IF MY BRAIN IS A CIRCULAR REFERENCE!
If I could please get some help, many I work with will also be thankful!
Here's the situation: --spreadsheet A, workbook 1 (thousands of rows): Col.A--00 through 20 Col.B--Acct. No. Col.C--Title Col.D--Balance --spreadsheet B, workbook 2: I want to search spreadsheet A, Col.A with a value of 01 and Col.D with a balance not equal to $0. If Col.A's value is 01 and Col.D is not zero, return the data for that row for all 4 columns. --spreadsheet C, workbook 3: Same as above except Col.A = 02. --etc., etc... Grazie!!! -- MVD San Francisco, California |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I FEEL AS IF MY BRAIN IS A CIRCULAR REFERENCE!
Good hevans, why seperate work books? Why not sheets in a workbook. Makes
the three demensional formulas much easier not to mention portabiltiy? "Candentco Creative Collection" wrote: If I could please get some help, many I work with will also be thankful! Here's the situation: --spreadsheet A, workbook 1 (thousands of rows): Col.A--00 through 20 Col.B--Acct. No. Col.C--Title Col.D--Balance --spreadsheet B, workbook 2: I want to search spreadsheet A, Col.A with a value of 01 and Col.D with a balance not equal to $0. If Col.A's value is 01 and Col.D is not zero, return the data for that row for all 4 columns. --spreadsheet C, workbook 3: Same as above except Col.A = 02. --etc., etc... Grazie!!! -- MVD San Francisco, California |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I FEEL AS IF MY BRAIN IS A CIRCULAR REFERENCE!
One should not solicit the heavens so quickly and without the benefit of the
know! Different workbooks are used because these spreadsheets are only a part of the bigger solution and opportunities. -- MVD San Francisco, California "Les Thompson" wrote: Good hevans, why seperate work books? Why not sheets in a workbook. Makes the three demensional formulas much easier not to mention portabiltiy? "Candentco Creative Collection" wrote: If I could please get some help, many I work with will also be thankful! Here's the situation: --spreadsheet A, workbook 1 (thousands of rows): Col.A--00 through 20 Col.B--Acct. No. Col.C--Title Col.D--Balance --spreadsheet B, workbook 2: I want to search spreadsheet A, Col.A with a value of 01 and Col.D with a balance not equal to $0. If Col.A's value is 01 and Col.D is not zero, return the data for that row for all 4 columns. --spreadsheet C, workbook 3: Same as above except Col.A = 02. --etc., etc... Grazie!!! -- MVD San Francisco, California |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I FEEL AS IF MY BRAIN IS A CIRCULAR REFERENCE!
Assuming your data starts in A2 (workbook1, SheetA). Type in the following
to cell A2 in Workbook2, SheetB - =IF(AND([Workbook1.xls]SheetA!$A2=1,[Workbook1.xls]SheetA!$D2<0),[Workbook1.xls]SheetA!A2,"") Drag the formula across to D2 and then drag it down as far as you have to go. Similar for other sheets and books Sandy "Candentco Creative Collection" .com wrote in message ... If I could please get some help, many I work with will also be thankful! Here's the situation: --spreadsheet A, workbook 1 (thousands of rows): Col.A--00 through 20 Col.B--Acct. No. Col.C--Title Col.D--Balance --spreadsheet B, workbook 2: I want to search spreadsheet A, Col.A with a value of 01 and Col.D with a balance not equal to $0. If Col.A's value is 01 and Col.D is not zero, return the data for that row for all 4 columns. --spreadsheet C, workbook 3: Same as above except Col.A = 02. --etc., etc... Grazie!!! -- MVD San Francisco, California |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I FEEL AS IF MY BRAIN IS A CIRCULAR REFERENCE!
Dear Sandy:
Many sincere thanks! The official formula turned out to be the following: =IF(AND('[Trial balance.xls]Sheet1'!$A1="01",'[Trial balance.xls]Sheet1'!$D1<0),'[Trial balance.xls]Sheet1'!A1,"") Now where this road ends, another appears. I will not be lazy though and will do my research first before beseeching help. Again, thank you. -- MVD San Francisco, California "Sandy" wrote: Assuming your data starts in A2 (workbook1, SheetA). Type in the following to cell A2 in Workbook2, SheetB - =IF(AND([Workbook1.xls]SheetA!$A2=1,[Workbook1.xls]SheetA!$D2<0),[Workbook1.xls]SheetA!A2,"") Drag the formula across to D2 and then drag it down as far as you have to go. Similar for other sheets and books Sandy "Candentco Creative Collection" .com wrote in message ... If I could please get some help, many I work with will also be thankful! Here's the situation: --spreadsheet A, workbook 1 (thousands of rows): Col.A--00 through 20 Col.B--Acct. No. Col.C--Title Col.D--Balance --spreadsheet B, workbook 2: I want to search spreadsheet A, Col.A with a value of 01 and Col.D with a balance not equal to $0. If Col.A's value is 01 and Col.D is not zero, return the data for that row for all 4 columns. --spreadsheet C, workbook 3: Same as above except Col.A = 02. --etc., etc... Grazie!!! -- MVD San Francisco, California |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular Reference | Excel Discussion (Misc queries) | |||
Circular reference help please! | Excel Discussion (Misc queries) | |||
Ho do I do this without a circular reference? | Excel Discussion (Misc queries) | |||
Circular Reference | Excel Worksheet Functions | |||
circular reference when using a UDF | Excel Worksheet Functions |