excel sheet king

126°
Deal Major
4,675
28535
50

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

15 Comments  |  
10 Dimers
  • Sort By
4,675
28535
50
Bulwark wrote:

Use sumif

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??

0
1430
4
Expand
homedimer wrote:

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??

Is it like you need to sum dr only if it has cr first in a row?

4,675
28535
50
Expand
161508-v2.0 wrote:

Is it like you need to sum dr only if it has cr first in a row?

bro, actually i m calculating turnover manually

now
there
buy
sell
buy
sell

like this 2000 enteries

any way to seprate buy firstly then sell

60
776
5
Expand
homedimer wrote:

bro, actually i m calculating turnover manually

now
there
buy
sell
buy
sell

like this 2000 enteries

any way to seprate buy firstly then sell

Use Right command. Like Right (A4,3) it will copy 3 characters from right i.e. Cr.

50
1874
9
Expand
homedimer wrote:

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 and then dr??

could you show some example/ format of the data?

By ‘nesting’ text functions like length, countif, right
within the “IF” function, one can selectively output select entries to say column N
the remsining entries in Column M
Then merge M and N in another column O
then
sort or sumif as @Pranav01 suggested above.

0
1430
4
Expand
homedimer wrote:

bro, actually i m calculating turnover manually

now
there
buy
sell
buy
sell

like this 2000 enteries

any way to seprate buy firstly then sell

If they are noted like the same(buy sell etc) you can make use of filter – apply filter, copy data, and sum..

Or u can use lookup functions and sum them.


If data is not confidential show some part and explain what you need to do.

50
1874
9

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.

4,675
28535
50
Expand
161508-v2.0 wrote:

If they are noted like the same(buy sell etc) you can make use of filter – apply filter, copy data, and sum..

Or u can use lookup functions and sum them.


If data is not confidential show some part and explain what you need to do.

which filter?

476
4436
51
Expand
homedimer wrote:

bro, actually i m calculating turnover manually

now
there
buy
sell
buy
sell

like this 2000 enteries

any way to seprate buy firstly then sell

if there is a separate column indicating the nature i.e. Buy/Sell or Dr/Cr, you can always use multi Sort option of excel (that particular column + date)
It would give the values sorted in order of Buy in order of dates and then Sell in order of dates.
If you do not want to change the order, you an add two more columns for Buy Cumulative and Sell Cumulative and then use a combination of IF command and addition.

273
5502
33

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

91
252
3

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

13
9881
143
Expand
homedimer wrote:

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??

Filter with cr

Missing