LinkBack URL
About LinkBacks
Hello. i need to create function using index and match that shows me every months cheapest and most expensive goods.
Data is in "Filtras" worksheet and function must be in "Pigiausia ir brangiausia prekė"
Hello. i need to create function using index and match that shows me every months cheapest and most expensive goods.
Data is in "Filtras" worksheet and function must be in "Pigiausia ir brangiausia prekė"
Last edited by romasasss; 05-28-2013 at 04:47 AM.
We need more info for this and even better a small sample workbiik..
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Also, please remember that most members may not be able to understand your language, and that could make it difficult for them to understand what you want and where you want it
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Originally Posted by FDibbins
Correct!
So 2 questions.
1) Will your data be only for 1 year or could be for several years?
2) You want to extract min-max values per month fron Filtras column H?
How we see the all date is of year 2001. so i need to extract min-max values per month fron Filtras column H.but min max must be of every month,by given datas. exp: Januray min max, february min max
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks