Problem Help Needed to Filter large data
I have two excel files
one main file contains all sunglasses models produced by the company about 240,000 entries
Second one contains a list of out of stock sunglasses models which is 1300 entries.
What is the best possible automated way to delete the out of stock models from main file using excel functions.
Desperately need help please anyone ?
Please help me 44 views and no help yet.
Hi Mughal,
Please use this function in cell Q2 of File SAFUPC :- =VLOOKUP(E2,'[outofstock-safilo.xlsx]Sheet1'!$C:$C,1,0)
Copy the same formula till the last cell Q14789,
Then use the Paste Special option
Select the range Q2:Q14789
Press Ctrl+C
Right click with the mouse
Choose paste special
select Values
Click on ok.
Now filter the data and Unselect the #N/A.
Then which data will be appear that would be out of Stock data
After Selecting the rows you can delete.
Thanks
Nisha Dhawan
If you like my answer please click on * Add Reputation
"If you can dream it, You can do it"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks