Please take a look at the attached document.
This shows an example of my 'dataset', and the layout of how I would like it to be transformed...
I would like to accomplish the "End Result" with the use of a formula only - and NO helper columns. - Array formulas are also fine.
** I don't want to use macros **
** I don't want to use pivot tables **
** I don't want to use filters **
I just want a formula or array formula to transform the dataset, into the End Result as shown in the example.
I have colour coded the data to make it easier for you to understand what's happening.
Please take a look and let me know if you are capable of helping me.
Thank you very much.
18 freelancers are bidding on average $103 for this job
Hello, I have created the formulas already! It was a challenge but I have done it :) No macros, no pivot, no array,no filters. Only plain formulas. Please open a chat with me. Kind regards, Sorin
"Hi, I would love to help you in your Current Project and it would be with confidence and satisfying results. I'm look forward to hearing from you about the project. Best Regards"
Dear, I'm mechanical engineer from Bosnia and Hercegovina with good experience in computer sciene I can finish this job very fast and quality. Best regards.
hi there, i used to create a template almost like your requirement for my previous company uaing google spreadsheet and using formulas only. no macros at all. i think this job can be done by me.
I can help you with anything with Excel. To prove it, I'm bidding the lowest. you can trust me with any Excel related. I'm rated 4.2/5 in ExcelChat(onine excel tutoring platform)
Yes - it is possible by using formula - However some sets of data will return blank Example: Ref 4 Match1 Ref 4 Ref 4 Thats the only way without using some automated manipulation