Find Sku Quantity in multiple column(racks)

AJJUBHAN

New Member
Joined
Jul 6, 2023
Messages
2
Office Version
  1. 2013
Platform
  1. Windows
Please Help To Find I Want to Find Sku Quantity in multiple column(racks)

Result Required
excel sample.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
1SKUNet QTYRACK-1RACK-2RACK-3RACK-4RACK-5RACK-6RACK-7RACK-8RACK-9RACK-10RACK-11RACK-12RACK-13RACK-14RACK-15RACK-16RACK-17RACK-18RACK-19RACK-20RACK-21RACK-22RACK-23RACK-24RACK-25RACK-26RACK-27RACK-28RACK-29RACK-30RACK-31
2SBA-6-7WINGS-ELA-DASHING-BLACK-600-SV0
3SBH-16-PULSE-DASHING-RED-560-CV0
4SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-BLUE-580-BLUE-VISOR4
5SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-BLUE-580-CV1
6SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-BLUE-580-NV-BLUE-VISOR0
7SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-BLUE-580-SV0
8SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-BLUE-600-BLUE-VISOR1
9SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-BLUE-600-CV30
10SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-BLUE-600-NV-BLUE-VISOR0
11SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-BLUE-600-SV0
12SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-GREY-580-BLUE-VISOR0
13SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-GREY-580-CV0
14SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-GREY-580-NV-BLUE-VISOR0
15SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-GREY-580-SV2
16SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-GREY-600-BLUE-VISOR0
17SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-GREY-600-CV31
18SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-GREY-600-NV-BLUE-VISOR0
19SBA-1-R2K-LIVE-GLOSSY-FLUO-NEON-GREY-600-SV0
20SBA-1-R2K-LIVE-GLOSSY-FLUO-ORANGE-BLUE-580-BLUE-VISOR1
21SBA-1-R2K-LIVE-GLOSSY-FLUO-ORANGE-BLUE-580-CV22
22SBA-1-R2K-LIVE-GLOSSY-FLUO-ORANGE-BLUE-580-NV-BLUE-VISOR0
Sheet1

Screenshot 2023-07-06 130704.png
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Transform your data into a list using Power Query to unpivot your racks columns. You should then be able to analyse the data more easily.
 
Upvote 0
Transform your data into a list using Power Query to unpivot your racks columns. You should then be able to analyse the data more easily.
thanks for the reply . i solved my problem With chat GPT
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,874
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top