Log In
Register
Home
No calculation for specific column
chanjong lee
New Member
Members
Forum Posts: 1
Member Since:
October 4, 2019
October 4, 2019
Offline1
October 4, 2019 - 2:14 am
In attached file,
Column A and B : No calculation when drag copying
Column C, D and G : Auto calculation for numbers when drag copying
How can change auto calculation for column C, D and G? Please help what to change.
Catalin Bombea
Iasi, Romania
Admin
Forum Posts: 1844
Member Since:
November 8, 2013
November 8, 2013
Offline2
October 4, 2019 - 1:23 pm
Hi,
C and D contains text, G has numbers. In text columns, if the number is at the end of the text, it will autofill the numbers when you drag down the cell. In case of column D, it will not work, because it is not ending in a numeric char. For column G, you have to select the last 2 cells and drag down, this way you will be able to fill series in numeric cells.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Leigh Thomas
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Trevor Pindling
Stevan Kanjo
Erin Sheldon
Nikita Bhatia
Sheilah Taylor
Clare Webber
David Jenssen
Dominic Brosnahan
Young You
Jennifer Owens
Forum Stats:
Groups: 3
Forums: 24
Topics: 6524
Posts: 28554
Member Stats:
Guest Posters: 49
Members: 32808
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —