|
|
checking input in a cell and return by copying info from a other c
What I want to do is the following. I have a worksheet in which I have
created the following; Name-Column , select-Column. I now want to created a
formula in a new sheet which check if the are "x" in the select column and
copy the names of the name-columns to cells in that new sheet. (which is in
the same workbook) is that possible? If so please let me know.
Thanks in advance.
|
|
0
|
|
|
|
Reply
|
 Utf
|
2/19/2010 3:30:01 PM |
|
To find a single "x" you would use VLOOKUP(). For all the "x"'s, see:
http://office.microsoft.com/en-us/excel/HA012260381033.aspx
--
Gary''s Student - gsnu201001
"Golf-Iron7" wrote:
> What I want to do is the following. I have a worksheet in which I have
> created the following; Name-Column , select-Column. I now want to created a
> formula in a new sheet which check if the are "x" in the select column and
> copy the names of the name-columns to cells in that new sheet. (which is in
> the same workbook) is that possible? If so please let me know.
>
> Thanks in advance.
|
|
|
0
|
|
|
|
Reply
|
Utf
|
2/19/2010 4:00:01 PM
|
|
"Gary"s Student;
Thanks for your answer but that is not quit what I was looking for. Maybe I
need to clearly explain what I want to do.
Column B contains "x" values which have been filled in in more than one
cell. (B1;B3;B5 etc) Column A contains Names. (A1;A3;A5 etc.) And now I want
in a different worksheet in the same workbook all the valves of Column A only
if Column B is "x"
The return value needs to be one per cell. So if there are let's say 3 names
each name needs to be returned in a different cell.
I think this can't be done with formules but maybe someone has got an idea.
"Gary''s Student" wrote:
> To find a single "x" you would use VLOOKUP(). For all the "x"'s, see:
>
> http://office.microsoft.com/en-us/excel/HA012260381033.aspx
> --
> Gary''s Student - gsnu201001
>
>
> "Golf-Iron7" wrote:
>
> > What I want to do is the following. I have a worksheet in which I have
> > created the following; Name-Column , select-Column. I now want to created a
> > formula in a new sheet which check if the are "x" in the select column and
> > copy the names of the name-columns to cells in that new sheet. (which is in
> > the same workbook) is that possible? If so please let me know.
> >
> > Thanks in advance.
|
|
|
0
|
|
|
|
Reply
|
Utf
|
2/19/2010 6:45:01 PM
|
|
Ok guys the following is the problem I really hope there is someone who can
help.
Sheet 1 contains the following.
Column A Column B
piet x
kees
jan x
joost x
etc
Sheet 2
Column A needs to show all the names in seperate cells which are marked with
a x in sheet 1.
Any idea !?!?!?!?!?!
"Golf-Iron7" wrote:
> "Gary"s Student;
>
> Thanks for your answer but that is not quit what I was looking for. Maybe I
> need to clearly explain what I want to do.
>
> Column B contains "x" values which have been filled in in more than one
> cell. (B1;B3;B5 etc) Column A contains Names. (A1;A3;A5 etc.) And now I want
> in a different worksheet in the same workbook all the valves of Column A only
> if Column B is "x"
>
> The return value needs to be one per cell. So if there are let's say 3 names
> each name needs to be returned in a different cell.
>
> I think this can't be done with formules but maybe someone has got an idea.
>
>
>
>
>
>
>
>
> "Gary''s Student" wrote:
>
> > To find a single "x" you would use VLOOKUP(). For all the "x"'s, see:
> >
> > http://office.microsoft.com/en-us/excel/HA012260381033.aspx
> > --
> > Gary''s Student - gsnu201001
> >
> >
> > "Golf-Iron7" wrote:
> >
> > > What I want to do is the following. I have a worksheet in which I have
> > > created the following; Name-Column , select-Column. I now want to created a
> > > formula in a new sheet which check if the are "x" in the select column and
> > > copy the names of the name-columns to cells in that new sheet. (which is in
> > > the same workbook) is that possible? If so please let me know.
> > >
> > > Thanks in advance.
|
|
|
0
|
|
|
|
Reply
|
Utf
|
2/24/2010 6:38:06 PM
|
|
Hi,
Try this.
Suppose your data is in range A2:B5 on sheet1. On sheet2, type * in cell
C3. In cell D3, enter the following array formula (Ctrl+Shift+Enter) and
copy down
=IF(ISERROR(INDEX(Sheet1!$A$1:$B$5,SMALL(IF(Sheet1!$B$1:$B$7=$C$3,ROW(Sheet1!$A$1:$A$7)),ROW(Sheet1!1:1)),1)),"",INDEX(Sheet1!$A$1:$B$5,SMALL(IF(Sheet1!$B$1:$B$7=$C$3,ROW(Sheet1!$A$1:$A$7)),ROW(Sheet1!1:1)),1))
Hope this helps.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Golf-Iron7" <GolfIron7@discussions.microsoft.com> wrote in message
news:F3E3681C-C065-4746-A557-0A6FBCF88284@microsoft.com...
> Ok guys the following is the problem I really hope there is someone who
> can
> help.
>
> Sheet 1 contains the following.
>
> Column A Column B
> piet x
> kees
> jan x
> joost x
> etc
>
> Sheet 2
>
> Column A needs to show all the names in seperate cells which are marked
> with
> a x in sheet 1.
>
>
> Any idea !?!?!?!?!?!
>
>
>
>
>
> "Golf-Iron7" wrote:
>
>> "Gary"s Student;
>>
>> Thanks for your answer but that is not quit what I was looking for. Maybe
>> I
>> need to clearly explain what I want to do.
>>
>> Column B contains "x" values which have been filled in in more than one
>> cell. (B1;B3;B5 etc) Column A contains Names. (A1;A3;A5 etc.) And now I
>> want
>> in a different worksheet in the same workbook all the valves of Column A
>> only
>> if Column B is "x"
>>
>> The return value needs to be one per cell. So if there are let's say 3
>> names
>> each name needs to be returned in a different cell.
>>
>> I think this can't be done with formules but maybe someone has got an
>> idea.
>>
>>
>>
>>
>>
>>
>>
>>
>> "Gary''s Student" wrote:
>>
>> > To find a single "x" you would use VLOOKUP(). For all the "x"'s, see:
>> >
>> > http://office.microsoft.com/en-us/excel/HA012260381033.aspx
>> > --
>> > Gary''s Student - gsnu201001
>> >
>> >
>> > "Golf-Iron7" wrote:
>> >
>> > > What I want to do is the following. I have a worksheet in which I
>> > > have
>> > > created the following; Name-Column , select-Column. I now want to
>> > > created a
>> > > formula in a new sheet which check if the are "x" in the select
>> > > column and
>> > > copy the names of the name-columns to cells in that new sheet. (which
>> > > is in
>> > > the same workbook) is that possible? If so please let me know.
>> > >
>> > > Thanks in advance.
|
|
|
0
|
|
|
|
Reply
|
Ashish
|
2/27/2010 4:07:35 AM
|
|
|
4 Replies
193 Views
(page loaded in 0.109 seconds)
Similiar Articles: Copy and Paste - microsoft.public.greatplains... using GP 10.00.1237 and we have a user that the CTRL C ... Hmmm....alternatively you might want to check the language ... Specifically the bank rec reconcile window - other bank ... If True then copy and paste, If False do nothing - microsoft ...'Repeat for other fields End If Of course, you ... Macro to copy paste values based on cell input ... Copy and move check box (check boxes) with new cell link ... How can I read CSV file using VBA? - microsoft.public.access ...... you help me run this code? i.e how can I check ... I would use 13 Line Input commands, parse the info then write it to a ... Read excel file and read in a cell into a var ... Replacing multiple instances of character - microsoft.public.excel ...... up of a WW2 pilot's logbook. For one set of information ... Then you can check down your column to see that this ... hence the suggestion to change 2 spaces to some other ... Inserting data into a Many to Many relationship - microsoft.public ...... Business table with a businessID and other information and a ... table', 16 , 1) RETURN end if exists ... Excel Macro: insert formula into first blank cell ... Permutation of an array - microsoft.public.vb.general.discussion ...> Thanks for your input. > Gary The algorithm is ... produces 134 million different iterations to check ... Return last and second last "populated" cell in column ... Return last ... IP address to Hostname in Excel - microsoft.public.excel ...I have 800+ IP addresses to check and output ... > > ' Some pages may also contain other copyrights by ... How do I return Hostname in excel cell by pinging IP address (VBA ... Equal list values. - microsoft.public.excel.programming ...... Alan 1234 Darren 2433 Tammi 2055 C... ... subsequent rows, do you mean manually drag every other ... way, if there's a query, I can show that I had no input ... formula R square - microsoft.public.mac.office.excel... clever enough to make a cell contents into anything else other than what it calculates. ... How do I do check boxes in cells ... Intro to File Input/Output in C - Computer Science Department at ...You can look up these other modes in a good C ... the files we opened above by copying each username and score from the input ... this error, fscanf() will not return ... Apply data validation to cells - Excel - Office.com... user enters data in the cell by copying ... these changes to all other cells with the same settings check box ... Make sure the Show input message when cell is selected check box ... Excel - Compare Cell A With Cell B Then Copy Value From Cell C To ...... Cell A With Cell B Then Copy Value From Cell C ... we take inventory at the store and input it the info into ... look up the number value in Column C, and in column D return a ... Developer’s Guide to the Excel 2010 Range ObjectCombining Ranges and Checking for ... Copying Ranges. The following sections ... through E15 and the focus was in cell D2, the CurrentRegion property would return a ... Excel :: Data Table - Input Cell On Different SheetData Table - Input Cell ... Copying Rows From ... then have it return the rest of the values on Sheet 1. The material is listed as the worksheet name and the other information ... 7/16/2012 7:34:42 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
39 followers. 