Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 74095 times)

Offline Centurion

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2012
  • Posts: 1304
  • Total likes: 2
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York / Jerusalem
  • Programs: spg plat,avis pres ,hertz plat ,AAexcutime, delta plat,hilton gold, united
Re: Excel Help and Problems
« Reply #1230 on: January 24, 2019, 09:58:26 PM »
How can I do this?
I need to create a column where every cell should have a date one month later than the previous. My particular case needs 120 months. So I can enter Jan. 1, 2019 in cell A1 and it should automatically fill in Feb. 1, 2019 in cell A2 and March 1, 2019 in cell A3 and so on for 120 rows.

Thanks.

type 01/01/2019 in first cell, then 02/01/2019 in second cell, then drag
you can only make a first impression ONCE

Offline Zubda

  • DansDeals Copper Elite
  • *
  • Join Date: Apr 2018
  • Posts: 16
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1231 on: January 24, 2019, 10:21:15 PM »
type 01/01/2019 in first cell, then 02/01/2019 in second cell, then drag
Lol, sometimes you only overthink and don't think of the simple ways

Online ludmila

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2012
  • Posts: 4483
  • Total likes: 179
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: IND
  • Programs: Hilton Diamond,Marriott Platinum,SPG Platinum.
Re: Excel Help and Problems
« Reply #1232 on: January 24, 2019, 10:24:05 PM »
Lol, sometimes you only overthink and don't think of the simple ways
+1 As we all do in most cases :)
I was the Best,still the Best, and will always be the Best.
Pele Good,Maradona Better, George Best.

Offline metsguy

  • Dansdeals Gold Elite
  • ***
  • Join Date: Apr 2011
  • Posts: 152
  • Total likes: 7
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1233 on: January 24, 2019, 10:57:29 PM »
+1 As we all do in most cases :)

As an excel Snob I would never consider a solution that involves a mouse.
Edate or Eomonth(A1,0)+1  FTW

Offline Zubda

  • DansDeals Copper Elite
  • *
  • Join Date: Apr 2018
  • Posts: 16
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1234 on: January 24, 2019, 11:00:45 PM »
As an excel Snob I would never consider a solution that involves a mouse.
Edate or Eomonth(A1,0)+1  FTW
Still requires a mouse (to drag down...)

Offline lubaby

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jun 2010
  • Posts: 4330
  • Total likes: 180
  • DansDeals.com Hat Tips 12
  • Gender: Male
    • View Profile
  • Location: New York
  • Programs: Hertz PC, National EE
Re: Excel Help and Problems
« Reply #1235 on: January 24, 2019, 11:02:13 PM »
Still requires a mouse (to drag down...)
Not if you know how to use your keyboard properly.
Once the game is over, the king and the pawn go back in the same box.

Offline Zubda

  • DansDeals Copper Elite
  • *
  • Join Date: Apr 2018
  • Posts: 16
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1236 on: January 24, 2019, 11:07:31 PM »
Not if you know how to use your keyboard properly.
Just tested it, and you've got a point!

Offline metsguy

  • Dansdeals Gold Elite
  • ***
  • Join Date: Apr 2011
  • Posts: 152
  • Total likes: 7
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1237 on: January 24, 2019, 11:14:12 PM »
Not if you know how to use your keyboard properly.

This.

Offline lubaby

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jun 2010
  • Posts: 4330
  • Total likes: 180
  • DansDeals.com Hat Tips 12
  • Gender: Male
    • View Profile
  • Location: New York
  • Programs: Hertz PC, National EE
Re: Excel Help and Problems
« Reply #1238 on: February 13, 2019, 08:20:30 PM »
Been trying to figure out a simple way to have a variable number (1-9) as part of an IF statement. Maybe someone here can help.

Text that Iím looking for the IF to match can be XYZ1, XYZ2, XYZ3 etc. There will always be an XYZ followed by 1-9 that I need it to pick up.
Currently I have it set to IF XYZ & cell reference (where I put in the 1-9 that it is), and the rest of my formulas work off that. I want to cut out the manually updating the cell reference each time I need my logic to populate.

Use case is in google sheets if that opens up more options.
Once the game is over, the king and the pawn go back in the same box.

Offline yesitsme

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2014
  • Posts: 1468
  • Total likes: 143
  • DansDeals.com Hat Tips 4
  • Gender: Male
    • View Profile
Re: Excel Help and Problems
« Reply #1239 on: February 13, 2019, 08:40:08 PM »
Been trying to figure out a simple way to have a variable number (1-9) as part of an IF statement. Maybe someone here can help.

Text that Iím looking for the IF to match can be XYZ1, XYZ2, XYZ3 etc. There will always be an XYZ followed by 1-9 that I need it to pick up.
Currently I have it set to IF XYZ & cell reference (where I put in the 1-9 that it is), and the rest of my formulas work off that. I want to cut out the manually updating the cell reference each time I need my logic to populate.

Use case is in google sheets if that opens up more options.
IF(Left(A2,3)="XYZ",1,2)?

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1286
  • Total likes: 109
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1240 on: February 13, 2019, 08:42:12 PM »
Been trying to figure out a simple way to have a variable number (1-9) as part of an IF statement. Maybe someone here can help.

Text that Iím looking for the IF to match can be XYZ1, XYZ2, XYZ3 etc. There will always be an XYZ followed by 1-9 that I need it to pick up.
Currently I have it set to IF XYZ & cell reference (where I put in the 1-9 that it is), and the rest of my formulas work off that. I want to cut out the manually updating the cell reference each time I need my logic to populate.

Use case is in google sheets if that opens up more options.
Wouldn't REGEXEXTRACT do it? (I didn't really chap the exact use...maybe it is too late in the day...)

Offline lubaby

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jun 2010
  • Posts: 4330
  • Total likes: 180
  • DansDeals.com Hat Tips 12
  • Gender: Male
    • View Profile
  • Location: New York
  • Programs: Hertz PC, National EE
Re: Excel Help and Problems
« Reply #1241 on: February 13, 2019, 08:50:31 PM »
IF(Left(A2,3)="XYZ",1,2)?
Forgot to mention, the XYZ # is in middle of a variable length and variable position of a string. The only absolute to work with is the XYZ #. Have it working now with a FIND XYZ & # from cell reference.

Wouldn't REGEXEXTRACT do it? (I didn't really chap the exact use...maybe it is too late in the day...)
I'm trying to cut off everything after the XYZ # (part of a larger data parsing project).

I'm not so familiar with REGEXEXTRACT. Will take a look.


ETA: REGEXEXTRACT worked perfectly. Thanks
"XYZ"&"[0-9]"
« Last Edit: February 13, 2019, 09:36:09 PM by lubaby »
Once the game is over, the king and the pawn go back in the same box.