Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summaryt Report
I have 3 worksheets in one workbook.
Either sheet 1, or sheet 2 will have data in it but not both. The third worksheet is a summary report that I want to draw certain cell contents into ie. Unit #, Serial Number, Make, Model etc. Sounds like an "either/or" function. Or should I use an "If then" function? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summaryt Report
This formula checks for data in both cells on sheet 1 or no data in either
cell and generates an error if so. If only one of the two cells has data, it copies the data to sheet2. The cells on sheet1 are A1 AND A2 =IF(OR(AND(Sheet1!A1="",Sheet1!A2=""),AND(Sheet1!A 1<"",Sheet1!A2<"")),"Houston, we have a problem",IF(Sheet1!A1<"",Sheet1!A1,Sheet1!A2)) "Fritz" wrote in message ... I have 3 worksheets in one workbook. Either sheet 1, or sheet 2 will have data in it but not both. The third worksheet is a summary report that I want to draw certain cell contents into ie. Unit #, Serial Number, Make, Model etc. Sounds like an "either/or" function. Or should I use an "If then" function? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summaryt Report
hi Fritz
If Sheet1 and Sheet2 are identical, I would use an IF(OR funtion. Something like =IF(OR(Sheet1!A10,Sheet2!A10),"Someting","Nothin g") HTH Michael M "Fritz" wrote: I have 3 worksheets in one workbook. Either sheet 1, or sheet 2 will have data in it but not both. The third worksheet is a summary report that I want to draw certain cell contents into ie. Unit #, Serial Number, Make, Model etc. Sounds like an "either/or" function. Or should I use an "If then" function? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summaryt Report
Hi Dave
I think the OP was looking for a comparison of Sheets1 & 2, not 2 cells in the one sheet ! Unless I'M wrong. !! Michael "Dave Thomas" wrote: This formula checks for data in both cells on sheet 1 or no data in either cell and generates an error if so. If only one of the two cells has data, it copies the data to sheet2. The cells on sheet1 are A1 AND A2 =IF(OR(AND(Sheet1!A1="",Sheet1!A2=""),AND(Sheet1!A 1<"",Sheet1!A2<"")),"Houston, we have a problem",IF(Sheet1!A1<"",Sheet1!A1,Sheet1!A2)) "Fritz" wrote in message ... I have 3 worksheets in one workbook. Either sheet 1, or sheet 2 will have data in it but not both. The third worksheet is a summary report that I want to draw certain cell contents into ie. Unit #, Serial Number, Make, Model etc. Sounds like an "either/or" function. Or should I use an "If then" function? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summaryt Report Corrected for data in A1 on Sheet1 and Sheet2 - result on Sheet3
This formula checks for data in cell A1 on both sheet1 and sheet2 or no data
in either cell and generates an error if so. If only one of the two cells has data, it copies the data to sheet3. The formula entered on some cell on Sheet3 is: =IF(OR(AND(Sheet1!A1="",Sheet2!A1=""),AND(Sheet1!A 1<"",Sheet2!A1<"")),"Houston, we have a problem",IF(Sheet1!A1<"",Sheet1!A1,Sheet2!A1)) "Fritz" wrote in message ... I have 3 worksheets in one workbook. Either sheet 1, or sheet 2 will have data in it but not both. The third worksheet is a summary report that I want to draw certain cell contents into ie. Unit #, Serial Number, Make, Model etc. Sounds like an "either/or" function. Or should I use an "If then" function? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summaryt Report Corrected for data in A1 on Sheet1 and Sheet2
Dave
I'm glad I emphasised the "Unless I'm wrong" part of my post. Regards Michael "Dave Thomas" wrote: This formula checks for data in cell A1 on both sheet1 and sheet2 or no data in either cell and generates an error if so. If only one of the two cells has data, it copies the data to sheet3. The formula entered on some cell on Sheet3 is: =IF(OR(AND(Sheet1!A1="",Sheet2!A1=""),AND(Sheet1!A 1<"",Sheet2!A1<"")),"Houston, we have a problem",IF(Sheet1!A1<"",Sheet1!A1,Sheet2!A1)) "Fritz" wrote in message ... I have 3 worksheets in one workbook. Either sheet 1, or sheet 2 will have data in it but not both. The third worksheet is a summary report that I want to draw certain cell contents into ie. Unit #, Serial Number, Make, Model etc. Sounds like an "either/or" function. Or should I use an "If then" function? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summaryt Report
=IF(Sheet1!A1="",Sheet2!A1,Sheet1!A1)
"Fritz" wrote: I have 3 worksheets in one workbook. Either sheet 1, or sheet 2 will have data in it but not both. The third worksheet is a summary report that I want to draw certain cell contents into ie. Unit #, Serial Number, Make, Model etc. Sounds like an "either/or" function. Or should I use an "If then" function? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summaryt Report
I thought I would join you all on this, like Fritz I have a similar workbook;
however, I have 2 sheets identical information that need to be merged into a summary, the 2 sheets are for 2 different people/cities to enter similar info to Fritz and the Summary sheet is for my manager to review both so we could do some analysis after the data is merged and not have to copy paste everytime they enter more data -- Thanks again, Herz and His "Teethless mama" wrote: =IF(Sheet1!A1="",Sheet2!A1,Sheet1!A1) "Fritz" wrote: I have 3 worksheets in one workbook. Either sheet 1, or sheet 2 will have data in it but not both. The third worksheet is a summary report that I want to draw certain cell contents into ie. Unit #, Serial Number, Make, Model etc. Sounds like an "either/or" function. Or should I use an "If then" function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Report W/Sub Report | Excel Discussion (Misc queries) | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Header in Report Manager Report | Excel Discussion (Misc queries) | |||
=(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)) Response | Excel Discussion (Misc queries) | |||
A pivot table report cannot overlap another pivot table report. | Excel Discussion (Misc queries) |