Search results

Mystery solved and thank you so much for the help!! I was actually having that same problem on another spreadsheet as well so that fixed them both! Thanks again, Leimst

I'm not able to get Count to work probably because the range contains text (people's names)?

Unfortunately, I'm at work and they do not allow us access to any of the upload sites. The only thing that I can tell is that I have 4 or 5 such Named Ranges and by the time I get done setting up one, the others have changed. Do I need $ signs in my formula somewhere?

Hello, I am using an Offset command in the "Refers To" line of the Name Manager in order to create a dynamic Named Range, e.g. =OFFSET('Dropdown info'!W$2,0,0,COUNTA('Dropdown info'!W:W)-1,1). However, I originally input the formula as =OFFSET('Dropdown info'!M$2,0,0,COUNTA('Dropdown...

Hello, I have made my first attempt at posting a document, chose Google Docs, and the link is: https://docs.google.com/file/d/0B8AkbgGt13FZTE5hTXlpUFNZZlE/edit. Please let me know if anyone has any trouble accessing. @Luke - I attempted to use the "=INDEX(A1:A4...

Thanks Montrey. Going to have to experiment some more with array formulas to get a better feel for them. I think I now have a pretty good grasp of Offset but not so much with the array formulas. Having been able to implement Luke M's formulas successfully, I did not think it would be difficult...

Luke-that was exactly what I needed...worked perfectly! Thank you so much! I'm not overly familiar with the Offset command but was able to apply it to the Store Number column in conjunction with a named range. Also, I've never used an array formual before and the Ctrl Shift Enter requirement...

A little elaboration: D A T A D E S I R E D R E S U L T S STORE NUMBER Highest Occurrence Number of Occurrences 473 473 4 428 452 473 481 428 452 473 481 473 428 Edited by Luke M to fix formatting w/ backticks.

First of all, thank you Hui for that formula. Have never seen that one before so I'll keep that in my back pocket for later! However, I neglected to mention that my store numbers are in a text format because sometimes the store numbers have leading zeroes. Also, I went ahead and tried to upload...

I could post the spreadsheet but there's really not that much to it in terms of the data that I am interested in which is just the first column which looks something like: STORE NUMBER 473 428 452 473 481 428 452 473 481 473 428 In this small scale example, 473 occurs 4 times which...

Hello, I have a report that has a column with store numbers in it. I need to come up with a formula that will search through the column and return the store that occurs the greatest number of times within that column. A caveat is that I would like to be able to use it on other spreadsheets...

Is there a good post on that Lymm?

Narayank991 - Unfortunately, I do not know VBA but want to start learning! SirJB7 - I couldn't agree with you more but wouldn't you know it...it's upper management that is utilizing this spreadsheet and therefore they are who I'm having trouble with! Thanks again for all of the help!

Thank you for the welcome. I love the site, forum and daily emails!!! Just discovered Chandoo.org about a month ago. Thanks also for the guidance...just wanted to make sure I was doing all I could! :) Leimst

I have a spreadsheet that requires periodic updating from approximately 10 different users. I'm trying to constrain and control their input because I'm finding that they are not following my directions, are adding rows and columns, inputting in the wrong columns among all the usual ways that...