Excel Data Cleansing Functions and Techniques | Tamil | Data Cleaning in Excel

[@ShinChan_GS]

Super

[@monishamohan8775]

Nice🤝

[@clicknlearn4517]

Thank yu 😊

[@manikandang1711]

Hai. Nice video. Enakku oru doubt A and B rows use pani. A rows la "Z" character use paniruken athula oru silla cells blank ah erukum. B rows la count pananum blank cell empty varanum athuku apparam "Z" character count panamum epolam blank cell varutha athuku Z value cell 1 erinthu count panamum. keela example kuduthuruken athu padi B rows la formula venum please help panunga
A B
~~ ~~~
Z 1
Z 2
Z 1
Z 2
Z 3
Z 1
Z 2

[@clicknlearn4517]

Y 1
Y 2
Y 3
0
Y 1
Y 2
0
Y 1
Y 2
Y 3
Y 4
In "B" column put 1 in the first cell and use this formula from second cell =IF(ISBLANK(A2),0,B1+1) Thanks for ur comments

[@manikandang1711]

@@clicknlearn4517 Ok bro super. Enoru Nan mention pana marathutha A rows la Nan formula apply paniruken "Z" character kuduthuruken. Athula Nala error varuthu B rows 1234567 nu continue ah varuthu bro.

[@clicknlearn4517]

Then Copy that whole A row and Paste as Values

[@manikandang1711]

@@clicknlearn4517 No bro. Oru oru time value enter aga methu athula Z varum athukku apparam count agamum. Ethaavathu solution eruka bro

[@clicknlearn4517]

Antha row yentha mathirinu full details therincha than bro formula use panalama paakalam