LinkBack URL
About LinkBacks
Hello Friends
I need to plot the texts in the given data range from vertical columns to horizontal cells and eliminating duplicates (plot duplicates first time only) as shown in light yellow cells by formula in Excel 2010 version.
thanks in advance.
Hello Friends
I need to plot the texts in the given data range from vertical columns to horizontal cells and eliminating duplicates (plot duplicates first time only) as shown in light yellow cells by formula in Excel 2010 version.
thanks in advance.
Sekar
Enter this in I5:
...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.Formula:
Please Login or Register to view this content.
Copy across.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Or try this ...
=IFERROR(INDEX($C$2:$C$466,AGGREGATE(15,6,ROW($B$2:$B$466)/($B$2:$B$466>=$F$5)/
($B$2:$B$466<=$G$5)/(COUNTIF($H$5:H$5,$C$2:$C$466)=0),1)-1),"")
Normal enter.
Or try this modification to Tony Valko's solution to your other post. Array entered.Formula:Please Login or Register to view this content.
Dave
Hello Olly, Phuocam, Dave
Thanks to all of you.
Your formulas working well.
thanks again.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also 'Add Reputation' to those who helped you. Thanks.
Sekars,
You're welcome. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks