|
|
|
|
|
|
|
1
|
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
|
16
|
17
|
18
|
19
|
20
|
21
|
22
|
|
23
|
24
|
25
|
26
|
27
|
28
|
29
|
|
30
|
31
|
|
|
|
|
|
|
|
27 registered members (kpswihart, Narrow Gap, Dead down wind, brushwhacker, Herdbull, Shmoe, Gunpowder, jawbone, Ten37, Jotjackson, eclipse829, twaldrop4, CKyleC, Dragfan66, Sandmtnslayer, StateLine, Jtide, DoeNut, Spec, BC, Jwbfx4, Cousneddy, Tree Dweller, 4 invisible),
705
guests, and 0
spiders. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
Re: Excel Proffesional..
[Re: countryjwh]
#4288710
02/19/25 03:50 PM
02/19/25 03:50 PM
|
Joined: Aug 2014
Posts: 21,255
Northport, AL
GomerPyle
Impatient Stinky Britches Wearin’ Off-Roadin’ Guru
|
Impatient Stinky Britches Wearin’ Off-Roadin’ Guru
Joined: Aug 2014
Posts: 21,255
Northport, AL
|
Don't hesitate to use ChatGPT for help with excel.......I use it all the time to help with complex formulas, formatting, etc. The trick is making sure you give it all the information about what the purpose of the spreadsheet, what you want to calculate, where various pieces of data are within the spreadsheet, etc. I worked for like 3 or 4 hrs one day on an IF formula that was like half a page long. Someone told me (after the fact) that I could've used AI for it so I tried it and it spit out the same thing in approximately 2.5 seconds.
you basically "explain" the spreadsheet to ChatGPT in as much detail as you can, then ask it to do [whatever]. You can probably even upload it to ChatGPT (assuming it's not confidential/sensitive info) and bypass the first part.
Last edited by GomerPyle; 02/19/25 03:52 PM.
There are 3 certainties in an uncertain world:
1. All Politicians Are Liars
2. All Gun Laws Are an Infringement
3. Taxation Is Theft
|
|
|
Re: Excel Proffesional..
[Re: GomerPyle]
#4289159
02/20/25 12:16 PM
02/20/25 12:16 PM
|
Joined: Nov 2008
Posts: 10,667
Alabama
whack-n-stack
Booner
|
Booner
Joined: Nov 2008
Posts: 10,667
Alabama
|
Don't hesitate to use ChatGPT for help with excel.......I use it all the time to help with complex formulas, formatting, etc. The trick is making sure you give it all the information about what the purpose of the spreadsheet, what you want to calculate, where various pieces of data are within the spreadsheet, etc. I worked for like 3 or 4 hrs one day on an IF formula that was like half a page long. Someone told me (after the fact) that I could've used AI for it so I tried it and it spit out the same thing in approximately 2.5 seconds.
you basically "explain" the spreadsheet to ChatGPT in as much detail as you can, then ask it to do [whatever]. You can probably even upload it to ChatGPT (assuming it's not confidential/sensitive info) and bypass the first part. Wow, I just did that and it's amazing what that thing can do.
|
|
|
Re: Excel Proffesional..
[Re: whack-n-stack]
#4289161
02/20/25 12:21 PM
02/20/25 12:21 PM
|
Joined: Aug 2014
Posts: 21,255
Northport, AL
GomerPyle
Impatient Stinky Britches Wearin’ Off-Roadin’ Guru
|
Impatient Stinky Britches Wearin’ Off-Roadin’ Guru
Joined: Aug 2014
Posts: 21,255
Northport, AL
|
Don't hesitate to use ChatGPT for help with excel.......I use it all the time to help with complex formulas, formatting, etc. The trick is making sure you give it all the information about what the purpose of the spreadsheet, what you want to calculate, where various pieces of data are within the spreadsheet, etc. I worked for like 3 or 4 hrs one day on an IF formula that was like half a page long. Someone told me (after the fact) that I could've used AI for it so I tried it and it spit out the same thing in approximately 2.5 seconds.
you basically "explain" the spreadsheet to ChatGPT in as much detail as you can, then ask it to do [whatever]. You can probably even upload it to ChatGPT (assuming it's not confidential/sensitive info) and bypass the first part. Wow, I just did that and it's amazing what that thing can do. Yep, and a little scary
There are 3 certainties in an uncertain world:
1. All Politicians Are Liars
2. All Gun Laws Are an Infringement
3. Taxation Is Theft
|
|
|
Re: Excel Proffesional..
[Re: GomerPyle]
#4289208
02/20/25 01:49 PM
02/20/25 01:49 PM
|
Joined: Feb 2019
Posts: 4,964
Montgomery,al,usa
Davyalabama
12 point
|
12 point
Joined: Feb 2019
Posts: 4,964
Montgomery,al,usa
|
Don't hesitate to use ChatGPT for help with excel.......I use it all the time to help with complex formulas, formatting, etc. The trick is making sure you give it all the information about what the purpose of the spreadsheet, what you want to calculate, where various pieces of data are within the spreadsheet, etc. I worked for like 3 or 4 hrs one day on an IF formula that was like half a page long. Someone told me (after the fact) that I could've used AI for it so I tried it and it spit out the same thing in approximately 2.5 seconds.
you basically "explain" the spreadsheet to ChatGPT in as much detail as you can, then ask it to do [whatever]. You can probably even upload it to ChatGPT (assuming it's not confidential/sensitive info) and bypass the first part. Wow, I just did that and it's amazing what that thing can do. Yep, and a little scary Yeah, ain't that the truth.
“If you do not conquer self, you will be conquered by self.” Napoleon Hill
The most difficult thing to understand during conversation is silence. Thoreau
|
|
|
Re: Excel Proffesional..
[Re: Beer Belly]
#4289241
02/20/25 03:10 PM
02/20/25 03:10 PM
|
Joined: Jan 2010
Posts: 3,779
south alabama
countryjwh
OP
10 point
|
OP
10 point
Joined: Jan 2010
Posts: 3,779
south alabama
|
I can’t post a picture. I can text a picture.
CHATGTP is way smarter than me... WOW.. I dont understand it fully but wow..
=IF([@CULL]="","",EDATE(D8372,(12*[@ALLOTMENT])))
Last edited by countryjwh; 02/20/25 03:16 PM.
|
|
|
Re: Excel Proffesional..
[Re: countryjwh]
#4289263
02/20/25 03:53 PM
02/20/25 03:53 PM
|
Joined: Mar 2013
Posts: 6,232
alex city
oakachoy
12 point
|
12 point
Joined: Mar 2013
Posts: 6,232
alex city
|
If cull is empty, it returns empty string
if not empty proceeds to date in cellD8372 plus number of months calculated multiplying 12 by value in allotment column
WM Hunter "Trump literally sacrificed himself, his family and all of his businesses for this country.
He literally is a true American hero. And True American Patriot - warts and all."
|
|
|
Re: Excel Proffesional..
[Re: countryjwh]
#4289341
02/20/25 06:12 PM
02/20/25 06:12 PM
|
Joined: Oct 2001
Posts: 26,793
Tampa
Beer Belly
Freak of Nature
|
Freak of Nature
Joined: Oct 2001
Posts: 26,793
Tampa
|
Yea my formula is wrong from somewhere down the stream. I sometimes get NA or not the correct date... I assume you are copying the formula down a column......... Do you always want it calculating from D8372? If so you may need to make it $D$8372.
|
|
|
Re: Excel Proffesional..
[Re: GomerPyle]
#4289438
02/20/25 08:33 PM
02/20/25 08:33 PM
|
Joined: Jan 2016
Posts: 1,880
Opelika Al
Madmax0818
8 point
|
8 point
Joined: Jan 2016
Posts: 1,880
Opelika Al
|
Don't hesitate to use ChatGPT for help with excel.......I use it all the time to help with complex formulas, formatting, etc. The trick is making sure you give it all the information about what the purpose of the spreadsheet, what you want to calculate, where various pieces of data are within the spreadsheet, etc. I worked for like 3 or 4 hrs one day on an IF formula that was like half a page long. Someone told me (after the fact) that I could've used AI for it so I tried it and it spit out the same thing in approximately 2.5 seconds.
you basically "explain" the spreadsheet to ChatGPT in as much detail as you can, then ask it to do [whatever]. You can probably even upload it to ChatGPT (assuming it's not confidential/sensitive info) and bypass the first part. ChatGPT is my go to for tons of things. Gomer knows the deal
|
|
|
Re: Excel Proffesional..
[Re: countryjwh]
#4289447
02/20/25 08:39 PM
02/20/25 08:39 PM
|
Joined: Oct 2001
Posts: 26,793
Tampa
Beer Belly
Freak of Nature
|
Freak of Nature
Joined: Oct 2001
Posts: 26,793
Tampa
|
No. It needs to copy the sale row cell. There just seems to be issues for some reason. There’s an allotment column that there cells link to another page. I think that’s the curve ball that I can’t hit. And figure out why it’s messing some of the column up. The delete that in the formula, and then go to the right place and click there.
|
|
|
|
(Custom).JPG)
