Menu

Is it possible to do this ...

Search this Thread

Prev

Previous Post

Next Post

Next

#1

Report Post

MarciaAnn

Posts: n/a

Default

Is it possible to do this ...

I have a 5-column set of data: Artists, US Sales Low, US Sales High,
ROW Sales Low, ROW Sales High. What I want to do is find the top 100
artists total, from both Sales High columns combined and conversely the
lowest 100. What formula would I use to make such a comparison?

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 06:51 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement