excel sheet king
- 578
- 16
-
- Last Comment
excel sheet king pls help me
i hv to total the debit and credit both enteries
now problem is both are mixed..
like cr-
dr
cr
cr
dr
dr
dr
pls help
- Sort By
any way to like this
make
cr cr
dr cr
cr cr
dr cr
Cr cr
cr dr
cr dr
dr dr
dr dr
credit enteries first then dr??
offtopic: there was a topic created by you once (in which @panchabhut quipped about seeing your posts after loooong. he seemingly missed to check your complete posts https://www.desidime.com/users/53930/posts?arch... including the archived ones)
did you got coerced into asking for it to be deleted (archived)
or
was it done by some content editor on their own?
just curious, nothing else.
I’m not sure if it is suggested earlier.
Here is a way. Go to Data Tab, Hit on Filter option. You can choose the required selections from the drop down
Use filter using contains Cr …. then use subtotal function to add only Cr part …. do same for Dr
another way is : use substring function to identify Cr or Dr & then concatenate the value in new column & sort it
https://i.imgur.com/zjwp3...ng
formula as of row 2
Use sumif