Hi Melinda You already have the fixed formulas in all the columns. Now you only need to check the length of the cell in column U to determine wh...
Hi James Attached are 2 methods that you can consider. One uses an array formula and the other uses a Pivot Table. Please note I have deleted...
Are you referring to the INDIRECT function? E.g. in cell A1 you have the text $Z$54. You can use INDIRECT($A$1) in all your formulas to reference t...
Hi Alan You can try this macro to change the color of the series. You will need to select the chart first before running the macro. Hope this...
Hi Todd Please attach a workbook with sample data for us to take a look.
Hi Ehab It is not practical to have unlimited competitors. I have set the output to 50 (even if you have more than 50) You will need to modify t...
Hi Aye Go with what Mynda suggested. Sunny
This is the updated version including number formatting. Good luck
Hi Aye Mu You can give this a try first. No time to look into the formatting of the output. Hope this helps. Sunny
Hi Ehab What you require is very complicated and difficult to do. I have to use some helper columns to get the desired result. Columns I and J c...
There is no attachment
Hi Alan There is no attachment.
If you only want to add a value and retain the original formula in the same cell, then maybe you can try using the N() function. Something like =SU...
Hi Ehab You are most welcome. Sunny
Hi Anders I was referring to this: =AND(ISTEXT(A1),EXACT(A1,UPPER(A1)),LEN(A1)=2,LEN(TRIM(A1))=2) or even this =AND(ISTEXT(A1),EXACT(A1,UP...