This is a ready program I am using answered by one of the experts here ,
It was ALKEY , was used for year end stock take for coding products while
physical count
I have now added one column the quantity column , formula on e3 do drag
down , kindly note to take into account the range f2 and G2 , since if
someone is selling to projects his quantity range search is above 500 cartons
Kindly open second attachment , first attach was a mistake
Last edited by makinmomb; 01-07-2015 at 10:57 AM.
I have attached two files by mistake , please use the second
Thanks FDBIBBINS i was able to delete the extra file away
Last edited by makinmomb; 01-07-2015 at 10:58 AM.
Formula for 4999 rows please as you can see the other formulas at this range
Please Login or Register to view this content.
Last edited by makinmomb; 01-07-2015 at 12:38 AM.
I realised all the 4 formulas will changes since they are linked to the quantity range
see the attached file
used vlookup from 2nd columun onwards
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
NFL i sneaked out of office to check , seems working , when I tested 30 X 44 on the keyword , it did not display result
It is working
Make sure the items have the quantities and the quantities matching with F1 & G1
If it is not working pls attach the excel sheet
Re attached file , worked for once on your sample qty on some
Added quantity on raw data , re tried , not working again
A formula works and then when I add data as paste special numbers ,
formula stops working , what does this mean , I have had this more than
one time ?
Worked again , it was not reading N/A on the quantity
NFL thanks , people at work rushed me emails they wanted the file badly
I will carry it for tomorrow morning on the working copy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks