Can i Turn off Excel Table Auto Fill formula For only 1 Column?

[blanx]

So have a unique situation. I had to rebuild my entire spread sheet and make it a table. This was because I had to have the auto fill formula feature.

After using this new method I've had 0 issues.

Now I've ran into a situation that only happens a few times a year, but it can be an issue.

Column G once in a while needs 1 and only 1 formula in just 1 row, in this case row 22. I do not need the rest of the rows to have the formula.

I created the master however I turned it over to someone else who will add this 1 formula each time its needed. It only occurs on holidays to factor in extra pay options during those days. the rest of the days will not need it, the rest of the days on the sheet are not holidays.

the real issue is the end user might need to add a row in above or below this 1 formula I can not have it copying each time.

Any suggestions?

 

[Yongle]

Keep it simple and create a formula that only returns a value if a condition is met

EXAMPLES
Using row number
=IF(ROW()<>22,"",[@Age])
(only row 22 returns a value, others blank)

Using value in another column etc
=IF([@Name]<>"John Smith","",[@Age])
(value only returned if name is "John Smith"

 

[blanx]

Keep it simple and create a formula that only returns a value if a condition is met

EXAMPLES
Using row number
=IF(ROW()<>22,"",[@Age])
(only row 22 returns a value, others blank)

Using value in another column etc
=IF([@Name]<>"John Smith","",[@Age])
(value only returned if name is "John Smith"

You are amazing, have no idea why I didn't think of that.

 

[GTS]

Hello,

The OP got a solution to their problem, but I am curious as to an answer to the original question.

I'm fairly new to the use of Tables. I have a Table where some columns are calculated and some are inputs. If the user decides to enter a formula as a means of entering their data (which is valid), then the formula gets replicated down the whole column. Granted, this is for the first entry. If an undo is performed, then the replication is reversed and one can continue on entering mixed data. I am aware that the replication can be turned off (globally) but this would defeat the purpose of using Tables in the first place.

So... "Can i Turn off Excel Table Auto Fill formula For only 1 Column?" Is there a way to do this?

 

[Yongle]

@GTS - that is an interesting new question - I do not think Excel allows you to be column-selective like that

But if you start a new thread for your question and post a link below , I will post a workaround that may be of interest to you

 

[GTS]

I am interested in the workaround. But I thought one was not supposed to start new threads with the same topic. My question is exactly what the OP put as the title to this thread. Any reason to not post it here? Thanks.

 

[Fluff]

As suggested by Yongle, please start a thread of your own, rather than resurrecting an old thread.