Find, match, alocate functions??

**blindesti** · 07-02-2013, 04:43 PM

Hello there, i will be verry happy if someone could help me. At work i do every week a statistic in excel and i need to analise around 2000 number and i do that manualy, look at this video to understand the ideea and what i do :

https://www.youtube.com/watch?v=E0bQXtw44Kw

can i code all this work or at least half of it, hope there is an way with macros or excel functions, you will save one day of my work guys...(kind of noob in vba/macro function.....) loked around the net, this site others and is kinda hard to find a propertly function...

Please who have a little ideea please help me!!!!

**blindesti** · 07-02-2013, 11:50 PM

http://www.youtube.com/watch?v=E0bQXtw44Kw if someone can really can help me here is the video doing my work-give some sugestion to simplify, thx...

**blindesti** · 07-04-2013, 07:17 AM

"1" mean for example : sheet2!A2 (thats "10")i search in sheet1!A:A, and i get last result founded and i look at colomn B for what is there, if there is "yes" in sheet2!B2 i write "1", if there is "no" then there i write "3"...after all i found that last result after search is in sheet1!A3 and ready to last result there is "yes" that mean that in sheet2!B2 i write "1"

next what "2" mean...for example next cell(sheet2!A3) the same contain "10" like was in (sheet2!A2)if both are equal then search stop and in sheet2!B3 i write "2"

next cell is sheet2!A4 is the same "10" the same result there must be in B4 "2"

next cell (sheet2!A5) is "14" after looking in sheet1!A:A i found that ready to last result there is "no" that mean that in sheet2!B5 there i write "3"...

and so on till the end....

sorry english is not my first language... xD

https://docs.google.com/spreadsheet/...ydzBVZkE#gid=1 this is an simple example of excel