Extracting Unique Data from Repeating Parameters in Excel: Dynamic Approach Needed

I know that this is a small data set, but I (and probably most people) am not going to take the time to create a workbook with your data. Including a sample workbook (see banner at the top of the page) will greatly enhance you chances that somebody will be willing to work your issues. I can do this with a combination of a pivot table and some vb code.

Try. In E4.

Formula:

Please Login or Register  to view this content.

Hi nilaakash , Currently your column C does not appear to be duplicated. Is there a possibility of duplication? Would You accept using EXCEL VBA CODE ?

What's the nature of the REAL data? If it's numeric, why did you show sample data that's text?

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Please read and act upon post #7.

There is no file attached - please try again.

But do you still need assistance? Or is it moot in the light of post #12?

What are your expected results in N2 and O2 (values)?

Maybe try:

=BYROW(H2:K5,LAMBDA(r,AVERAGE(r)))

=BYROW(H2:K5,LAMBDA(r,MEDIAN(r)))

=BYROW(H2:K5,LAMBDA(r,STDEV.P(r)))

for kvsrinivasamurthy, who provided me with a helpful code.

Anyone can offer help.

Thank you sincerely for providing your code. Your dynamic solution is truly appreciated. However, I've encountered an issue with the H column in my own code—it's not dynamic, requiring manual dragging to populate values completely. I'm seeking assistance to make this part of the code dynamic as well. Any help would be greatly valued.

For this to work properly, KM's formula will need to be tweaked:

Please Login or Register  to view this content.

However, I've encountered an issue with the H column in my own code

Fixed in post #19.

EDIT: You don't need your formula - it's all done in KM's tweaked formula that I provided in post #19. These are formulae, not code - code is VBA.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Thank you, AliGW, for sharing your code. I'll need some time to grasp it fully since I'm not an Excel expert. If I encounter any difficulties or uncertainties, would it be possible for me to reach out to you for assistance?

Just post again to this thread if you need help with this FORMULA (not code).

For any new queries, start a new thread.

For now, if that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Try. single formula in D4. Last 3 columns are average, median, sd.

Formula:

Please Login or Register  to view this content.

Thank you again, kvsrinivasamurthy, for your assistance with the code. I was hoping for a slightly different approach, where the codes are separated into three different cells for clarity. I appreciate your willingness to incorporate my input into your file. If possible, could you please integrate your code accordingly? Your responsiveness is greatly valued.


extracting unique data_nil.xlsx

In D13

Formula:

Please Login or Register  to view this content.

In G13

Formula:

Please Login or Register  to view this content.

In L13

Formula:

Please Login or Register  to view this content.

Thank you, kvsrinivasamurthy, for providing such efficient codes. Your kindness and expertise are truly appreciated.
Best regards.


Once again, these are FORMULAE, not code or codes.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Thank you, AliGW. You're correct; these are indeed formulas, not codes. I attempted to add reputation by clicking on the * button, but unfortunately, it didn't work. I'm unsure why.

Didn't work? Did you get an error message? There should be no problam for you as a brand new member.

Please take a look at the attached file, where it indicates, "You must spread some Reputation around before giving it to kvsrinivasamurthy again." I may be wrong.

star.jpg

That means that you have already awarded that member reputation. However, I have not had any from you, so it should work for me.

Please stop quoting unnecessarily.

You seem to have sorted it now - thank you.