Results 1 to 3 of 3

Changing two or more data points in one cell using Autofill

Threaded View

  1. 09-05-2020, 01:37 PM #3
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,329

    Re: Changing two or more data points in one cell using Autofill

    Not sure what you want but this is my guess
    =IF(ROW()-2>=$A$1;"";"Vintage "&$A$1-ROW(A1)+1&"th birthday shirt - "&TEXT(TODAY();"mmmm ")&YEAR(TODAY())-$A$1+ROW(A1)-1&" Shirt - "&$A$1-ROW(A1)+1&" Years Old Birthday Gift")
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Line Graph with Changing Data Points (Text Boxes)
    By JPRICH16 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-03-2019, 06:29 PM
  2. [SOLVED] Changing which cell a formula points to automatically??
    By heytherejem in forum Excel General
    Replies: 5
    Last Post: 07-07-2017, 03:33 PM
  3. [SOLVED] Username to autofill in when changing data on row
    By JDobbsy1987 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2017, 08:50 PM
  4. Color chart data points/marker points vba error
    By nmckever in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-12-2014, 07:10 AM
  5. Calculating Slope and Intercept with a changing number of data points
    By WE5T in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2013, 05:48 AM
  6. [SOLVED] Autofill with changing data
    By Mags in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2005, 06:05 PM
  7. [SOLVED] cell height changing when using autofill
    By WSCI-Nathan in forum Excel General
    Replies: 1
    Last Post: 01-17-2005, 08:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1