Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=if or not?
Hello,
Immediately below is a report I need to export into another report. Sheet 1: Column A shows the date, Column B shows the time frame, you can ignore column C, Column D shows the number of calls that came in during Column Bs timeframe and Column E shows the number of abandoned calls. Sheet 1 A B C D E Date Time Collated Time Answered Calls Abandoned Calls 8/29/2004 7:00:00 1800 0 0 8/29/2004 7:30:00 1800 0 0 8/29/2004 8:00:00 1800 2 0 8/29/2004 8:30:00 1800 2 0 8/29/2004 9:00:00 1800 9 0 8/29/2004 9:30:00 1800 5 0 8/29/2004 10:00:00 1800 4 0 8/29/2004 10:30:00 1800 9 1 8/29/2004 11:00:00 1800 5 1 8/29/2004 11:30:00 1800 7 0 What I need to do is bring the data from sheet 1 into sheet 2. For example if the Sheet 1 column B matches Sheet 2 column B then the date will be brought over to column A, Answered calls will be brought over for column c, etc€¦ Now an =if may work but keep in mind that the data from sheet 1 will not always be in the same cell. The location of the data on sheet 1 does vary from day to day. Sheet 2 A B C D E Date Time Answered Calls Abandoned Calls Offered Calls 7:00:00 7:30:00 8:00:00 8:30:00 9:00:00 9:30:00 10:00:00 10:30:00 11:00:00 11:30:00 Thanks for the help!!! |