+ Reply to Thread
Results 1 to 5 of 5

trying to change a number in repeating cells that also contain a letter such as D1, D2, D3

  1. #1
    Registered User
    Join Date
    06-15-2014
    Posts
    13

    Exclamation trying to change a number in repeating cells that also contain a letter such as D1, D2, D3

    Hi guys, i have a strange one, im a reasonable excel user but can work out if this is possible..

    ok i need a formula for a sign in sheet for the academy i work at. we have night and day classes of the same sessions, in the planner they are listed as d1, d2 d3 and n1 n2 n3 and so on for each.

    so basically im trying to create a formula to quickly ender the d1, d2, d3 ect into the cells on eachpage for the students to sign in for each day it works out to be about 190 calls and 9 diferent classes to you can see why id like to speed this up. problem is i need the number to change not the D and excel want to use the cell allocation.. i hope that makes scence..


    as you can see from the document i have not attatched, i have created a formula to add in the dates automatically, i would like to do the same with the session numbers or the D numbers, this is one of the shorter courses and has about 190 days, so any time saving tips would be greatly apreciated
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by cdemery; 06-16-2014 at 07:50 PM. Reason: correct forum rule errors.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,186

    Re: i need a strange formula..

    Hi, cdemery,

    welcome to ExcelForum. Please have a read at Forum Rule #1 about thread titles and change the one for this thread.

    And maybe consider to attach a workbook as a reference instead of pictures.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    06-15-2014
    Posts
    13

    Re: trying to change a number in repeating cells that also contain a letter such as D1, D2

    updated.. hope thats better..

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,186

    Re: trying to change a number in repeating cells that also contain a letter such as D1, D2

    Hi, cdemery,

    maybe you should have a look at the spacing you use. The frst 3 sets of data have an empty row between each while between set 3 and 4 due to a change of pages there´s none. Maybe you consider to add a line to the end of teh first print page in order to get things evenly distributed.

    I changed the formats and formulas for the first set of data regarding the number as well as the day.

    For Range B9 there´s just the number 1 which gets entered while the formatting for the cell looks like
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    For Range C9 I changed the contents to
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and the format to
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    I hope I figured out what you wanted.

    Ciao,
    Holger
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-15-2014
    Posts
    13

    Re: trying to change a number in repeating cells that also contain a letter such as D1, D2

    you are a sir are a gentleman thanks!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Strange Conditional Formula
    By holly3251 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-28-2016, 12:12 AM
  2. Strange formula: =IDX1
    By nsv in forum Excel General
    Replies: 2
    Last Post: 08-08-2008, 07:48 AM
  3. Help with Strange Formula
    By scr5jo in forum Excel General
    Replies: 5
    Last Post: 07-03-2006, 05:40 AM
  4. [SOLVED] Strange formula 'non-calculation'
    By ednakayama@gmail.com in forum Excel General
    Replies: 1
    Last Post: 04-29-2006, 06:22 PM
  5. Strange formula popping up
    By lil'bit in forum Excel General
    Replies: 8
    Last Post: 11-09-2005, 09:40 PM

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