Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find a cell in a range and copy another cell
I need to select two cells in two ranges that meet two criteria's from
another sheet in the spreadsheet, one criteria is todays date and the other is the letter s or c ie coulumn A row 1-2000, column B row 1-2000 Then once I find the cell that meets the criteria I need to copy another cell in the same row What I am trying to accomplish is: Someone is inputing sales and cost data every day - I would like a summary sheet showing only today's data The data sheet looks like this Column A-Row 1 - march 3, 2008, Column B-Row 1 - s, Column C-Row 1 - 255 Column A-Row 2 - march 3, 2008, Column B-Row 2 - c, Column C-Row 2 - 166 Column A-Row 3 - march 4, 2008, Column B-Row 3 - 2, Column C-Row 3 - 333 I would like the summary sheet to take items from column C that meet the criteria of today's date and s and put in the data from column C ie if today is march 3 - I want to have 255 in the cell I tried doing it myself and used the following formula without success - I always end up with zero instead of the value in the cell in column c =IF(AND('Ser Data'!A7:A2120=TODAY(),'Ser Data'!B7:B2120="s"),'Ser Data'!C7:C2120,0) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find a cell in a range and copy another cell
=IF(AND('Ser Data'!A7:A2120=TODAY(),'Ser Data'!B7:B2120="s"),'Ser
Data'!C7:C2120,0) Try this, paste into the formula bar, then array-enter by pressing CTRL+SHIFT+ENTER to confirm the formula (instead of just pressing ENTER): =IF(ISNA(MATCH(1,('Ser Data'!A7:A2120=TODAY())*('Ser Data'!B7:B2120="s"),0)),0,INDEX('Ser Data'!C7:C2120,MATCH(1,('Ser Data'!A7:A2120=TODAY())*('Ser Data'!B7:B2120="s"),0))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "confused" wrote: I need to select two cells in two ranges that meet two criteria's from another sheet in the spreadsheet, one criteria is todays date and the other is the letter s or c ie coulumn A row 1-2000, column B row 1-2000 Then once I find the cell that meets the criteria I need to copy another cell in the same row What I am trying to accomplish is: Someone is inputing sales and cost data every day - I would like a summary sheet showing only today's data The data sheet looks like this Column A-Row 1 - march 3, 2008, Column B-Row 1 - s, Column C-Row 1 - 255 Column A-Row 2 - march 3, 2008, Column B-Row 2 - c, Column C-Row 2 - 166 Column A-Row 3 - march 4, 2008, Column B-Row 3 - 2, Column C-Row 3 - 333 I would like the summary sheet to take items from column C that meet the criteria of today's date and s and put in the data from column C ie if today is march 3 - I want to have 255 in the cell I tried doing it myself and used the following formula without success - I always end up with zero instead of the value in the cell in column c =IF(AND('Ser Data'!A7:A2120=TODAY(),'Ser Data'!B7:B2120="s"),'Ser Data'!C7:C2120,0) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy range and paste into every 3rd cell of new range | New Users to Excel | |||
find last cell in range with data, display cell address | Excel Worksheet Functions | |||
Find a Cell Value In a Range | Excel Worksheet Functions | |||
Find if any cell in range is above Zero | Excel Discussion (Misc queries) | |||
Find and copy part of a cell | Excel Worksheet Functions |