+ Reply to Thread
Results 1 to 6 of 6

Location of Changing Cell Values

  1. #1
    Registered User
    Join Date
    06-11-2007
    Posts
    24

    Formula help

    Hi

    I was wondering if anyone could help to solve the following problem (attached is the sheet):

    I need to have the count of numbers 1 to 10 in different columns on the attached sheet. The issue is each number 1 to 10 has a dash and changes each day, eg. 1-1 and then I will change it to 1-2 and then 1-3 and so on. Each number will be located somewhere on the sheet and some columns will have multiple numbers in them, eg. Row 1 could contain 1-7 and 2-9 and so on. So to find it 1-* and so on is required I think. The cells in the box are formatted as “text” to get the dash working.

    1) I would like the count to appear beside each number in the count column eg. 1-22 beside the number 1.
    2) I would also like to have the row location for each number as well under the “row” column

    Thanks so much for any help you could give. I’ve spent 8 hours and can’t seem to get it.
    Last edited by mike4545; 06-14-2007 at 08:32 PM.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    HI

    I think you have attached the wrong file - this is a repeat of your question.


    rylo

  3. #3
    Registered User
    Join Date
    06-11-2007
    Posts
    24

    Correct file is attached.

    The correct file has been uploaded.

    Mike

  4. #4
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Mike

    Can please you upload a spreadsheet, not a word document, and show both your source data, and the expected result for the sample data given.


    rylo

  5. #5
    Registered User
    Join Date
    06-11-2007
    Posts
    24
    The web site will not let me upload an excel file. The file size is only 14kb! Any ideas.

    Mike

  6. #6
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    Try zipping the file then uploading.


    rylo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1