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: 1807
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: Mark Carlson
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
yashal minahil
Oluwadamilola Ogun
Yannik H
dectator mang
Francis Drouillard
Orlando Inocente
Jovitha Clemence
Maloxat Axmatovna
Ricardo Freitas
Marko Meglic
Forum Stats:
Groups: 3
Forums: 24
Topics: 6201
Posts: 27185
Member Stats:
Guest Posters: 49
Members: 31861
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —