Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to reference a cell?
Hello,
I apologize if this is a duplicate. I posted my question earlier but it doesn't seem to have shown up so I'm going to try again. This is what I need. If N2="YES" I need K2 to populate in B2. Any suggestions? Thanks in advance, tgcali |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to reference a cell?
I posted a reply, here is a copy
In B2 type =IF(N2="Yes",K2,"") Modify the "" to whatever you need, e.g. "Not Found" or whatever. If N2 is not Yes, the above will return an empty string. Position the cursor toward the bottom right of B2 until it turns into a crosshair, then click to grip the cell, drag down as far as you need. -- Tim Zych www.higherdata.com Compare data in Excel and find differences with Workbook Compare A free, powerful, flexible Excel utility "tgcali" wrote in message ... Hello, I apologize if this is a duplicate. I posted my question earlier but it doesn't seem to have shown up so I'm going to try again. This is what I need. If N2="YES" I need K2 to populate in B2. Any suggestions? Thanks in advance, tgcali |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to reference a cell?
Worked like a charm Tim, thank you so much. Sorry about the duplicate post,
wasn't showing up for me. tgcali "Tim Zych" wrote: I posted a reply, here is a copy In B2 type =IF(N2="Yes",K2,"") Modify the "" to whatever you need, e.g. "Not Found" or whatever. If N2 is not Yes, the above will return an empty string. Position the cursor toward the bottom right of B2 until it turns into a crosshair, then click to grip the cell, drag down as far as you need. -- Tim Zych www.higherdata.com Compare data in Excel and find differences with Workbook Compare A free, powerful, flexible Excel utility "tgcali" wrote in message ... Hello, I apologize if this is a duplicate. I posted my question earlier but it doesn't seem to have shown up so I'm going to try again. This is what I need. If N2="YES" I need K2 to populate in B2. Any suggestions? Thanks in advance, tgcali |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to reference a cell?
Tim,
How do I make the results show at the top of the page? Thanks again. tgcali "Tim Zych" wrote: I posted a reply, here is a copy In B2 type =IF(N2="Yes",K2,"") Modify the "" to whatever you need, e.g. "Not Found" or whatever. If N2 is not Yes, the above will return an empty string. Position the cursor toward the bottom right of B2 until it turns into a crosshair, then click to grip the cell, drag down as far as you need. -- Tim Zych www.higherdata.com Compare data in Excel and find differences with Workbook Compare A free, powerful, flexible Excel utility "tgcali" wrote in message ... Hello, I apologize if this is a duplicate. I posted my question earlier but it doesn't seem to have shown up so I'm going to try again. This is what I need. If N2="YES" I need K2 to populate in B2. Any suggestions? Thanks in advance, tgcali |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to reference a cell?
If you're talking about Outlook Express, you can sort by the "Sent" date.
Click that header so that a down arrow appears in it. -- Tim Zych www.higherdata.com Compare data in Excel and find differences with Workbook Compare A free, powerful, flexible Excel utility "tgcali" wrote in message ... Tim, How do I make the results show at the top of the page? Thanks again. tgcali "Tim Zych" wrote: I posted a reply, here is a copy In B2 type =IF(N2="Yes",K2,"") Modify the "" to whatever you need, e.g. "Not Found" or whatever. If N2 is not Yes, the above will return an empty string. Position the cursor toward the bottom right of B2 until it turns into a crosshair, then click to grip the cell, drag down as far as you need. -- Tim Zych www.higherdata.com Compare data in Excel and find differences with Workbook Compare A free, powerful, flexible Excel utility "tgcali" wrote in message ... Hello, I apologize if this is a duplicate. I posted my question earlier but it doesn't seem to have shown up so I'm going to try again. This is what I need. If N2="YES" I need K2 to populate in B2. Any suggestions? Thanks in advance, tgcali |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to reference a cell?
Tim,
No, I meant for this list. I have pulled the data with your help, but the results have several blank rows. I was asking if I could get them to display at the top of the page. Sorry for any confusion. tgcali "Tim Zych" wrote: If you're talking about Outlook Express, you can sort by the "Sent" date. Click that header so that a down arrow appears in it. -- Tim Zych www.higherdata.com Compare data in Excel and find differences with Workbook Compare A free, powerful, flexible Excel utility "tgcali" wrote in message ... Tim, How do I make the results show at the top of the page? Thanks again. tgcali "Tim Zych" wrote: I posted a reply, here is a copy In B2 type =IF(N2="Yes",K2,"") Modify the "" to whatever you need, e.g. "Not Found" or whatever. If N2 is not Yes, the above will return an empty string. Position the cursor toward the bottom right of B2 until it turns into a crosshair, then click to grip the cell, drag down as far as you need. -- Tim Zych www.higherdata.com Compare data in Excel and find differences with Workbook Compare A free, powerful, flexible Excel utility "tgcali" wrote in message ... Hello, I apologize if this is a duplicate. I posted my question earlier but it doesn't seem to have shown up so I'm going to try again. This is what I need. If N2="YES" I need K2 to populate in B2. Any suggestions? Thanks in advance, tgcali |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to reference a cell?
Ah, I though your post was buried and you wanted to know how to see it.
Sort the data. Be sure to include the the data as well as the new formula and sort by the helper formula "descending". Select the table. Data - Sort. "Sort by" the helper formula column "descending". Be sure to choose the option whether the data range has "header row" or "no header row". -- Tim Zych www.higherdata.com Compare data in Excel and find differences with Workbook Compare A free, powerful, flexible Excel utility "tgcali" wrote in message ... Tim, No, I meant for this list. I have pulled the data with your help, but the results have several blank rows. I was asking if I could get them to display at the top of the page. Sorry for any confusion. tgcali "Tim Zych" wrote: If you're talking about Outlook Express, you can sort by the "Sent" date. Click that header so that a down arrow appears in it. -- Tim Zych www.higherdata.com Compare data in Excel and find differences with Workbook Compare A free, powerful, flexible Excel utility "tgcali" wrote in message ... Tim, How do I make the results show at the top of the page? Thanks again. tgcali "Tim Zych" wrote: I posted a reply, here is a copy In B2 type =IF(N2="Yes",K2,"") Modify the "" to whatever you need, e.g. "Not Found" or whatever. If N2 is not Yes, the above will return an empty string. Position the cursor toward the bottom right of B2 until it turns into a crosshair, then click to grip the cell, drag down as far as you need. -- Tim Zych www.higherdata.com Compare data in Excel and find differences with Workbook Compare A free, powerful, flexible Excel utility "tgcali" wrote in message ... Hello, I apologize if this is a duplicate. I posted my question earlier but it doesn't seem to have shown up so I'm going to try again. This is what I need. If N2="YES" I need K2 to populate in B2. Any suggestions? Thanks in advance, tgcali |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to reference a cell?
In O2: =IF(N2="Yes",ROW(),"")
Leave O1 blank In P2: =IF(ROWS($1:1)COUNT(O:O),"",INDEX(K:K,SMALL(O:O,R OWS($1:1)))) Select O2:P2, copy down to cover the max expected extent of data in col N. Col P will return the results from col K, all neatly bunched at the top as required. -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- "tgcali" wrote: No, I meant for this list. I have pulled the data with your help, but the results have several blank rows. I was asking if I could get them to display at the top of the page. Sorry for any confusion. tgcali |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to reference a cell?
Tim and Max,
Thank you both so much. I got it now. You are always such a big help! I appreciate it. tgcali "Max" wrote: In O2: =IF(N2="Yes",ROW(),"") Leave O1 blank In P2: =IF(ROWS($1:1)COUNT(O:O),"",INDEX(K:K,SMALL(O:O,R OWS($1:1)))) Select O2:P2, copy down to cover the max expected extent of data in col N. Col P will return the results from col K, all neatly bunched at the top as required. -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- "tgcali" wrote: No, I meant for this list. I have pulled the data with your help, but the results have several blank rows. I was asking if I could get them to display at the top of the page. Sorry for any confusion. tgcali |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to reference a cell?
Welcome, and thanks for feeding back.
-- Max Singapore http://savefile.com/projects/236895 Downloads: 15,500, Files: 352, Subscribers: 53 xdemechanik --- "tgcali" wrote in message ... Tim and Max, Thank you both so much. I got it now. You are always such a big help! I appreciate it. tgcali |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |