Ok, you've not answered my last query so I've made an attempt based on what I think you want. It's an array formula so needs to be entered with ctrl+shift+Enter hope it's right Oh and by the way, i've put your answer on sheet 2, ignore what is on sheet one as thats a response to a different query by someone else and can't be bothered making another sample sheet
Last edited by scottylad2; 12-18-2010 at 01:39 PM. Reason: error typing
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
For your first reply. If the only Type I have are all Veterans, I would use the the LARGE function and using the first mentioned column as my array and number 2 as my K.
For the 2nd reply. I think what you did on your sample is the one I am trying to do for 3 days now.
Thank you very much scottylad2.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks