There are a lot of duplicate data so I really don't know what is your expected output. Just give me a few example of what is expected in column H (...
Hi David Don't quite understand your question. Can you provide some example of the expected output as per your attachment.
Hi Carolyn You could use a Pivot Table but first you need to create a Helper Column. Please refer attachment. Hope this helps. Sunny
Hi Debra If ADN is the highest, BSN is 2nd and MSN is 3rd (hope I am correct) then you can just sort your data based on NAME (or ID to make it uniq...
Hi Ditran In your situation I would normally use a macro to merge the data. Using formulas is too complex. You can look into this article to ...
Hi Samantha How I wished I knew the answer At this moment I really have no idea. I am only guessing it could be due to the grouping of the dat...
Hi Donald In cell N20 your formula should be =INDEX($F$20:$F$25,MATCH(K20,$E$20:$E$25,0)) You can refer here for more details on INDEX/MATCH ...
Hi Mariya You can give this a try. You will need to select the required range one by one (eg A2:D4) before clicking the MERGE button. Then co...
Unfortunately I am not familiar with them. Maybe others could assist you on these.
Hi Dritan Are you referring to Google Sheets? I have very little experience using Google Sheets. It doesn't support VBA but uses GScript instead...
Hi Dritan/Saleha No problem Glad to know it is helpful. Sunny
Hi David Your data is pretty messy. A lot of cleansing/converting/formatting is required before the report could be generated. Since your attach...
Hi Samantha You can try this. 1) Select the column chart one by one 2) Drop the Project Name field to the Column Header 3) Unfilter the Pr...
Hi Dritan Protecting your Project Press ALT-F11 Select Tools-VBAProject Properties… Select the Protection tab Check Lock project from viewi...
I have modified the file and added Admin as one of the user. The password is Admin. You can change it later if you wish. Only the Admin can see the...