LinkBack URL
About LinkBacks
Sheet 1 I need ranking between the two columns, Rank 1 would be the highest ave cube based on highest ave items
Sheet 2 I need ranking between the two columns, Rank 1 would be the highest ave rating based on the lowest ave items
Thanks!Wwar.xlsx
Ranking based on two columns
Sheet 1 I need ranking between the two columns, Rank 1 would be the highest ave cube based on highest ave items
Sheet 2 I need ranking between the two columns, Rank 1 would be the highest ave rating based on the lowest ave items
Thanks!Wwar.xlsx
Last edited by wwar; 07-31-2024 at 05:34 PM. Reason: Fixed formatting on feedback
Please update your profile with the version of Excel you are using.
Hi and welcome to the forum
Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.
Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Try this spill formula:
=XLOOKUP(A2:A1106*1000+B2:B1106/1000;SORT(A2:A1106*1000+B2:B1106/1000;;-1);SEQUENCE(ROWS(A2:A1106)))
Can be simplified to:
=XMATCH(A2:A1106*1000+B2:B1106/1000;SORT(A2:A1106*1000+B2:B1106/1000;;-1);0)
Keep getting an error message when trying to input the formula. the error is shownScreenshot 2024-08-01 103905.pngScreenshot 2024-08-01 103905.png via screenshot
Change all semi-colons to commas.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
This formula looks like the weight of the cube far outstrips the weight of the sales. A 80/20 weight is preferred when comparing items(sales) to the cubic area. First rank should show the highest cubic by vs items sale at a ratio of 80/20(sales/cubic) any suggestions?
The weightage you give will severely affect the ranking when # of items is significantly higher than cubic.
Screenshot 2024-08-02 091128.png
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks