I have the following formula:
=IF($AT$122:$BX$122=K$4,(IF(OR($AT$147:$BX$166="R"),"R",IF(OR($AT$147:$BX$166="Y"),"Y","G"))),"G")
AT122:BX122 - Contains a work of date.
K4 - Contains the date to be reported on.
AT147:BX166 - Contains a status for a processing site ("R", "Y", or "G")
I am trying to get the reporting cell to display an "R" if any of the cells
in the column that has the date that matches K4 has an "R" in it. If there
are no "R"s in that column, then display a "Y" if there are any "Y"s in the
column. If there are no "R" or "Y" values, then display a "G".
At this point, the reporting cell shows an "R" or a "Y" if any cell in the
AT147:BX166 range contains an "R" or a "Y", regardless of the date.
Can someone help?
Thank you
|
|
0
|
|
|
|
Reply
|
 Utf
|
1/11/2010 5:18:02 PM |
|
Hi,
try
=IF(AND($AT$122:$BX$122=K$4,$AT$147:$BX$166="R"),"R",IF(AND($AT$122:$BX$122=K$4,$AT$147:$BX$166="Y"),"Y","G"))
"Raul" wrote:
> I have the following formula:
>
> =IF($AT$122:$BX$122=K$4,(IF(OR($AT$147:$BX$166="R"),"R",IF(OR($AT$147:$BX$166="Y"),"Y","G"))),"G")
>
> AT122:BX122 - Contains a work of date.
> K4 - Contains the date to be reported on.
> AT147:BX166 - Contains a status for a processing site ("R", "Y", or "G")
>
> I am trying to get the reporting cell to display an "R" if any of the cells
> in the column that has the date that matches K4 has an "R" in it. If there
> are no "R"s in that column, then display a "Y" if there are any "Y"s in the
> column. If there are no "R" or "Y" values, then display a "G".
>
> At this point, the reporting cell shows an "R" or a "Y" if any cell in the
> AT147:BX166 range contains an "R" or a "Y", regardless of the date.
>
> Can someone help?
>
> Thank you
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
1/11/2010 7:58:08 PM
|
|
|
1 Replies
593 Views
(page loaded in 0.036 seconds)
Similiar Articles: Test cells for values if date matches - microsoft.public.excel ...I have the following formula: =IF($AT$122:$BX$122=K$4,(IF(OR($AT$147:$BX$166="R"),"R",IF(OR($AT$147:$BX$166="Y"),"Y","G"))),"G") AT122:BX122 - C... test to see if string matches with cell content - microsoft.public ...Test cells for values if date matches - microsoft.public.excel ... test to see if string matches with cell content - microsoft.public ... Test cells for values if date ... Macro to match 2 column values in different sheets - microsoft ...Macro to match 2 column values in different sheets - microsoft ... Update Cell in Multiple Sheets ... ... Match values in more than one column - microsoft.public ... Copying a cell if dates match - microsoft.public.excel.worksheet ...Test cells for values if date matches - microsoft.public.excel ... Macro to match 2 column values in different sheets ... MS Excel: Test each value in column A and copy ... Match (1 of 3 cell values) in a range? - microsoft.public.excel ...Test cells for values if date matches - microsoft.public.excel ... Match (1 of 3 cell values) in a range? - microsoft.public.excel ... Test cells for values if date ... Checking Cell Value for a Date - microsoft.public.excel ...Test cells for values if date matches - microsoft.public.excel ... Test to see if cell contains a space? - microsoft.public.excel ... Checking Cell Value for a Date ... test - microsoft.public.dotnet.framework.aspnettest to see if string matches with cell content - microsoft.public ... If I have the ... Test cells for values if date matches - microsoft.public.excel ... I have the ... Test to see if cell contains a space? - microsoft.public.excel ...Checking Cell Value for a Date - microsoft.public.excel ... Test cells for values if date matches - microsoft.public.excel ... Test to see if cell contains a space ... Compare 1 cell to column of cells returning adjacent cells info ...Test cells for values if date matches - microsoft.public.excel ... Compare 1 cell to column of cells returning adjacent cells info ... Test cells for values if date ... Macro to subtract cells if... - microsoft.public.excel.programming ...Test cells for values if date matches - microsoft.public.excel ... Macro to subtract cells if... - microsoft.public.excel.programming ... Test cells for values if date ... Test cells for values if date matches - microsoft.public.excel ...I have the following formula: =IF($AT$122:$BX$122=K$4,(IF(OR($AT$147:$BX$166="R"),"R",IF(OR($AT$147:$BX$166="Y"),"Y","G"))),"G") AT122:BX122 - C... Macro to highlight a row if cells match value [Solved] | Kioskea.netBest answer: Hi Sgriffis, Try this code: Sub test() Set MR = Range("E1:E100") For Each cell In MR If cell.Value >= 50 And cell.Offset(0, 3).Value <= Date Then cell ... Check if a cell contains text - Excel - Office.comIf you need to find text values that share some characters but not others, use a ... Check if part of a cell matches specific text. To do this task, use the IF, SEARCH and ... MS Excel: Test each value in column A and copy matching values ...MS Excel: Test each value in column A and copy matching values ... write an Excel macro that needs to compare data in Cell A2 to A3 and so on until it doesn't find a match? VBA Coding to Test Multiple Values - dBforums... VBA statement to test an Excel column for five values. When the procedure finds the targets, other cells in ... Join Date: Jan 2002 ... was 13 it would match any value with ... 7/30/2012 5:16:08 PM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
66 followers. 