Forum Discussion
Excel Online Conditional Formatting - Unable to Edit Existing Rules
Hi, I have a file that was originally created in Excel Desktop. We are wishing to move the file to only online to prevent change/version errors. The conditional formats that were created on desk...
Dear Sir,
Please see the below table.
NAME COCACOLA HOSLICS ICE CREAM BISCUITS
KADAPA 100 25 10 68
HYDERABAD 41 53 57 94
KARIMNAGAR 42 69 38 28
VIJAYWADA 19 91 73 37
I need to excel formula is below as per below table please confirm the same.
NAME COCACOLA HOSLICS ICE CREAM BISCUITS
KADAPA 100
KADAPA 25
KADAPA 10
KADAPA 68
Please see the below table.
NAME COCACOLA HOSLICS ICE CREAM BISCUITS
KADAPA 100 25 10 68
HYDERABAD 41 53 57 94
KARIMNAGAR 42 69 38 28
VIJAYWADA 19 91 73 37
I need to excel formula is below as per below table please confirm the same.
NAME COCACOLA HOSLICS ICE CREAM BISCUITS
KADAPA 100
KADAPA 25
KADAPA 10
KADAPA 68
Malleshg0072035 Hi, this involves a bit of work. Just follow the steps below:
1. In cell A8, type NSA2, and in Cell B8 type NSB2
NS is just 2 random alphabets, now you need to use the find and replace option. Find "NS" and replace with "="
You will get your answer as:
So basically what we are doing is referring to the cell addresses and getting the answer. This shall be quicker method to use