Home
What's new
Latest activity
Authors
Store
Latest reviews
Search products
Forums
New posts
Search forums
What's new
New posts
New listings
New products
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
Cart
Cart
Loading…
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Change style
Contact us
Close Menu
Forums
SVTPerformance's Chain of Restaurants
Road Side Pub
Learning Excel
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="RX1Cobra" data-source="post: 15631852" data-attributes="member: 139306"><p>I don't have time to check my thoughts but... First you can do a sumif. Your sumif will be based on the sku and the sum will be net available. This will get you how many you have based on sku but will duplicate the number for any item with the same sku.</p><p></p><p>I'd copy the sum result and paste it as a value. Sort by cost (lowest first), remove duplicates (reason we pasted as value) based on sku and I think you'll net what you're looking for. Could be an easier way but this is a pretty simple macro if you use macro the record macro function.</p></blockquote><p></p>
[QUOTE="RX1Cobra, post: 15631852, member: 139306"] I don't have time to check my thoughts but... First you can do a sumif. Your sumif will be based on the sku and the sum will be net available. This will get you how many you have based on sku but will duplicate the number for any item with the same sku. I'd copy the sum result and paste it as a value. Sort by cost (lowest first), remove duplicates (reason we pasted as value) based on sku and I think you'll net what you're looking for. Could be an easier way but this is a pretty simple macro if you use macro the record macro function. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
SVTPerformance's Chain of Restaurants
Road Side Pub
Learning Excel
Top