Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Function to pull a single cell from a column into another cell
This is probably just a simple function, but i don't know what it is. I have a column of information that is being pulled from an adjacent column where only 1 cell will have anything in it but 0. I need to pull whatever cell in the columns information to a single cell somewhere else. Is there a function for this? thanks in advance new here...
|
#2
|
|||
|
|||
Quote:
|
#3
|
|||
|
|||
I have 2 columns with if formulas in them. The first on pulls the highest number in from a list that meets a certain criteria. Making only 1 cell in the column a number above 0. The second column pulls text from the row that has that number in it. I am then trying to pull that text from any cell in the column up to another cell for easy reference.
Example: Destination cell(want to pull "Text" to here) Column 1: Column 2: 0 0 0 0 0 0 0 0 0 0 10 Text 0 0 0 0 0 0 My spacing in my examples didnt work, but does that help any? |
#4
|
|||
|
|||
Quote:
An actual workbook is always an easier way to get the point across, but I THINK I get what you mean. Have a look at the attachment... |
#5
|
|||
|
|||
Yep that worked thanks a ton. Next time i will just post the workbook. New and didn't realize i could attack it. Thanks again. I work in excel a ton and have kinda taught myself how to use it. Just discovered this site and am learning a ton from reading other posts.
|
#6
|
|||
|
|||
Quote:
I'm self taught too and always happy to help. So look forward to reading your next query :) |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to pull a single cell from a column into another cell
I
have a column of information that is being pulled from an adjacent column where only 1 cell will have anything in it but 0. I need to pull whatever cell in the columns information to a single cell somewhere else. Suppose B is the column with only 1 cell will have anything in it but 0. Suppose A is the column to pull information from. If the non-zero cell in column B is always a positive number, then try: =INDEX(A:A,MATCH(MAX(B:B),B:B,0)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function needed to pull in cell values | Excel Programming | |||
single-cell multiple entry with pull-down list? | Excel Discussion (Misc queries) | |||
From single cell variables to a single column serie | New Users to Excel | |||
I cannot select a single cell or pull down cell contents | Excel Worksheet Functions | |||
pull value from last cell in a column | Excel Programming |