Move contents of cells based on condition
I am new to excel and learning it. I have about 500 records in excel sheet containing year and names and race timings. These contents are filtered on year basis. I have placed the filtered records in second sheet. Now I want to move the contents of these filtered rows to another location based on name entered by user in a cell. the formula should copy all rows with the row containing name entered by user in a cell as the first row in the new list. Can anybody guide me with this ?
Hi and welcome to the forum.
Be sure that best way to describe your problem is to upload a sample workbook.
Be sure that all sensitive data removed, showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that.
To attach a small sample workbook.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I have attached a small excel file. Can you check it out ?
I use d2 different formulas.
For the first name this one.
Formula:
=INDEX(A$2:A$15;MATCH("*"&$D$2&"*";$A$2:$A$15;0))
For ALL the others this ARRAY one.
Formula:=IFERROR(INDEX(A$2:A$15;SMALL(IF($A$2:$A$15<>$D$15;ROW(A$2:A$15)-1);ROW(A1)));"")
Comments?
-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.
Mr Fortis why can't you use =IF(COUNTIF($D$15:$E15,A2)>0,A3,A2) instead of =IFERROR(INDEX(A$2:A$15;SMALL(IF($A$2:$A$15<>$D$15;ROW(A$2:A$15)-1);ROW(A1)));"")
Did i say that we can not use this?Originally Posted by nflsales
No i didn't.
Nice Thought! Just fix the result in F14..
Also if the times are uniques we could use a simple INDEX & MATCH in F4 and copy down.
Formula:=INDEX($B$2:$B$13,MATCH(E4,$A$2:$A$13,0))
Please try this file.
Last edited by ramananhrm; 09-13-2013 at 06:12 AM.
Please click 'Add reputation', if my answer helped you.
see the attachement
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks