hi guys,
i have in worksheet Data columns with startdates;employee names and numbers
i want in sheet Column K the startdates ordererd from early to late based on day and employee
see attachment for example
kind regards
hi guys,
i have in worksheet Data columns with startdates;employee names and numbers
i want in sheet Column K the startdates ordererd from early to late based on day and employee
see attachment for example
kind regards
Try
C4Formula:Please Login or Register to view this content.
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
HI shukla.ankur281190,
Thanks but that is not all what i want.
if i put the formula in cel D4 is gives me the result of C4. And i want only the startdates from C4 of 2-1-2017 and not others if i pull down the formula
see attachment
Place your expected result with your sample file
see my earlier post. i have attached my sample file
Array formula in B4, copied across and down:
=IFERROR(INDEX(Data!$K:$K,SMALL(IF(Data!$M$2:$M$1988='Column K'!$B$2,IF(INT(Data!$K$2:$K$1988)='Column K'!B$3,ROW(Data!$M$2:$M$1988))),ROWS(B$4:B4))),"")
Last edited by Glenn Kennedy; 11-23-2017 at 09:22 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
that is awesome Thanks a lot!
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
Hi Glenn Kennedy,
can you help me with the same formula but tranposed to columns
See attachments sheet New Columns K
Back in an hour....
Try
=IFERROR(INDEX(Data!$K$2:$K$2000,SMALL(IF((INT(Data!$K$2:$K$2000)=$A3)*(Data!$M$2:$M$2000=$A$1),ROW(Data!$K$2:$K$2000)-ROW($K$2)+1,""),COLUMNS($A:A))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Hi John Topley,
The formula doesn't work.
could you place the sample file including your formula and dragged down if possible
See attached (assuming I understood requirement)
I didn't look at JT's attachment...
=IFERROR(INDEX(Data!$K:$K,SMALL(IF(INT(Data!$K$2:$K$2000)=$A3,IF(Data!$M$2:$M$2000=$A$1,ROW(Data!$K$2:$K$2000))),COLUMNS($A:A))),"")
array entered.
Apply the formulaFormula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks