Forum Discussion
Excel Online Conditional Formatting - Unable to Edit Existing Rules
Manage rules now available in Excel Online
but so far you can only check them and delete. Adding new rules and editing is coming.
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
1) that is separated question, much better to start new thread in such case.
2) Much better if you provide sample file instead of numbers within post
3) In general that's job for Power Query - query the table, select name and unpivot other columns
- Dear Sir,
Thanks for your replying.
Regards
Mallesh
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
