Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How identify data of two coulams,Every cell count and show result
Q1. How identify data of two coulams
Q2. Every cell count and show result like I need like Coulam A Coulam B 500 1 500 2 500 3 800 1 800 2 800 3 800 4 800 5 800 6 600 1 600 2 600 3 600 4 700 1 700 2 I want to count like coulam B i have data in coulam A and like this I have two coulam with name as lower,upper,propercase i want to do all in same case like in proper case how? |
#2
|
|||
|
|||
Hi
In column B enter =COUNTIF($A$1:A1,"="&A1) copy down column B as far as required To convert to proper case, assuming data is in column C, in column D enter =Proper(C1) Copy down column D as far as required. Then copy the whole of column D, locate cursor in cell A1 and EditPaste SpecialValues. You can then delete column D. Regards Roger Govier pooja wrote: Q1. How identify data of two coulams Q2. Every cell count and show result like I need like Coulam A Coulam B 500 1 500 2 500 3 800 1 800 2 800 3 800 4 800 5 800 6 600 1 600 2 600 3 600 4 700 1 700 2 I want to count like coulam B i have data in coulam A and like this I have two coulam with name as lower,upper,propercase i want to do all in same case like in proper case how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Splitting Data in a Cell | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
sending data from one cell to another (not using copy & paste) | Excel Worksheet Functions |