FabSwingers.com mobile

Join us FREE, we're FREE to use

Web's largest swingers site since 2006.

Already registered?
Login here

Back to forum list
Back to The Lounge

excel experts?

Jump to newest
 

By *ittle_brat_evie!! OP   Woman
over a year ago

evesham

I know there must be some on here!

I have a problem that I know (or think I know) excel can sort but I can't for the life of me think of the formula, or maybe I need a macro?!

Reply privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago

Haven't used it in a while but may be able to help. What's the issue

Reply privatelyReply in forumReply +quote
 

By *reelove1969Couple
over a year ago

bristol

could you tell us what the problem is ?

Reply privatelyReply in forumReply +quote
 

By *av1970Man
over a year ago

Tattershall

But what is the problem you are having? Not an expert but use it regularly

Reply privatelyReply in forumReply +quote
 

By *ittle_brat_evie!! OP   Woman
over a year ago

evesham

OK....I have a table of data with names unique numbers in the first column although these numbers can be replicated in the data as it relates to people ordering things...in the end column is the numerical total of the order.

I would like excel to create a separate table where by it searches the first column and makes it so there are no duplications and adds up the total cost of their order so they are not charged in 2 transaction.

Quite confusing to write down

Reply privatelyReply in forumReply +quote
 

By *av1970Man
over a year ago

Tattershall

Sounds like you need to create a pivot table, the table can then show the unique reference and the sum total of all order values against that reference ...are you using 2010 as it is a lot easier to do.

Reply privatelyReply in forumReply +quote
 

By *ittle_brat_evie!! OP   Woman
over a year ago

evesham


"Sounds like you need to create a pivot table, the table can then show the unique reference and the sum total of all order values against that reference ...are you using 2010 as it is a lot easier to do."

unfortunately not, 2003

I tried a pivot table but it wouldn't add up the cost of the orders,just returned the count of data.

Reply privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago

[Removed by poster at 26/02/15 20:19:31]

Reply privatelyReply in forumReply +quote
 

By *av1970Man
over a year ago

Tattershall

Ahh in 2010 you can change the output from count to sum and lots of others. Am sure you can do it in other versions but not sure how...sorry.

Reply privatelyReply in forumReply +quote
 

By *ittle_brat_evie!! OP   Woman
over a year ago

evesham


"Have you tried to SUM the values in the column?"

it's not the sum of all the orders I need. I need a list of each order where multiple orders are added together.

So if.....

1 - 5

2 - 7

3 - 2

4 - 6

5 - 3

1 - 3

3 - 4

6 - 8

I'd want a formula that would give me

1 - 8

2 - 7

3 - 6

4 - 6

5 - 3

6 - 8

Does that make sense?

Reply privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago

Maybe

=IF(AND(COUNTIF(A$1:A1,A1)=COUNTIF(A:A,A1),COUNTIF(A:A,A1)1),SUMIF(A:A,A1,B:B),"")

Reply privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago

Pivot table. Double click in the pivot table once you've produced it (if it's still returning a count) and there will be an option to change the result to sum.

Reply privatelyReply in forumReply +quote
 

By *ittle_brat_evie!! OP   Woman
over a year ago

evesham

Ooh will try both of those, thanks

Reply privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago

Ps it's usually blank cells or cells with text in that makes it return a count instead of a sum, so you could go through to remove any blanks too.

Reply privatelyReply in forumReply +quote
 

By *av1970Man
over a year ago

Tattershall

Just did a quick try with a pivot in an old version of excel i still have...and as above you should be able to highlight the cells that are giving a count, right click and change the field settings to sum.

Reply privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago

http://excel-templates.blogspot.co.uk/

Reply privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago

Sumif(....)

Reply privatelyReply in forumReply +quote
 
 

By (user no longer on site)
over a year ago

Create one formulae for each client, or what ever the first column is.

Reply privatelyReply in forumReply +quote
Post new Message to Thread
back to top