| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy from Two Cells
Hello,
I have two columns, each with a Vlookup to seperate spreadsheets. Each column will have either a "Y" or and #NA."Y" represnting that a client has enrolled in a meeting, #NA from Vlookup in either one or both columns if the client has not enrolled in either meeting. So I want a third column to have a "Y" if there is a "Y" either coluimn A or B in the same row.(or conversly a "N" if there is not a Y in either column Thank you in advance for saving me from pulling anyu more hair out. Help here is always terriffic. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from Two Cells
One Way:
=IF(COUNTIF(A1:B1,"Y"),"Y","N") HTH, Paul -- "Steve B" wrote in message ... Hello, I have two columns, each with a Vlookup to seperate spreadsheets. Each column will have either a "Y" or and #NA."Y" represnting that a client has enrolled in a meeting, #NA from Vlookup in either one or both columns if the client has not enrolled in either meeting. So I want a third column to have a "Y" if there is a "Y" either coluimn A or B in the same row.(or conversly a "N" if there is not a Y in either column Thank you in advance for saving me from pulling anyu more hair out. Help here is always terriffic. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from Two Cells
This assumes the ONLY POSSIBLE cell values are Y and #N/A
=if(and(iserror(cell1),iserror(cell2)),"N","Y") "Steve B" wrote: Hello, I have two columns, each with a Vlookup to seperate spreadsheets. Each column will have either a "Y" or and #NA."Y" represnting that a client has enrolled in a meeting, #NA from Vlookup in either one or both columns if the client has not enrolled in either meeting. So I want a third column to have a "Y" if there is a "Y" either coluimn A or B in the same row.(or conversly a "N" if there is not a Y in either column Thank you in advance for saving me from pulling anyu more hair out. Help here is always terriffic. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from Two Cells
=IF(OR(A1="y",B1="y"),"y","n")
-- Gary''s Student - gsnu200738 "Steve B" wrote: Hello, I have two columns, each with a Vlookup to seperate spreadsheets. Each column will have either a "Y" or and #NA."Y" represnting that a client has enrolled in a meeting, #NA from Vlookup in either one or both columns if the client has not enrolled in either meeting. So I want a third column to have a "Y" if there is a "Y" either coluimn A or B in the same row.(or conversly a "N" if there is not a Y in either column Thank you in advance for saving me from pulling anyu more hair out. Help here is always terriffic. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from Two Cells
Try this:
=IF(AND(ISNA(A1),ISNA(B1)),"N","Y") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steve B" wrote in message ... Hello, I have two columns, each with a Vlookup to seperate spreadsheets. Each column will have either a "Y" or and #NA."Y" represnting that a client has enrolled in a meeting, #NA from Vlookup in either one or both columns if the client has not enrolled in either meeting. So I want a third column to have a "Y" if there is a "Y" either coluimn A or B in the same row.(or conversly a "N" if there is not a Y in either column Thank you in advance for saving me from pulling anyu more hair out. Help here is always terriffic. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from Two Cells
Thank you to all 4 who answered. Problem solved.
"Ragdyer" wrote: Try this: =IF(AND(ISNA(A1),ISNA(B1)),"N","Y") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steve B" wrote in message ... Hello, I have two columns, each with a Vlookup to seperate spreadsheets. Each column will have either a "Y" or and #NA."Y" represnting that a client has enrolled in a meeting, #NA from Vlookup in either one or both columns if the client has not enrolled in either meeting. So I want a third column to have a "Y" if there is a "Y" either coluimn A or B in the same row.(or conversly a "N" if there is not a Y in either column Thank you in advance for saving me from pulling anyu more hair out. Help here is always terriffic. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| How do I fill (copy) nonadjacent cells to adjacent cells? | Excel Discussion (Misc queries) | |||
| how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| Copy cells into range of cells until cell change | Excel Worksheet Functions | |||
Linear Mode
