Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-07-2019, 12:53 PM   #16
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,931
Thanks: 114
Thanked 2,990 Times in 2,719 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Magic formula appears

The link you provided says:
Quote:
Extend data range formats and formulas

Select to automatically format new items added to the end of a list to match the format of the rest of the list. Formulas that are repeated in every row are also copied. To be extended, formats and formulas must appear in at least three of the five last rows preceding the new row.
Missing a row doesn't flout what the final sentence says.
I think what matters is the preceding sentence that I've marked in bold

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 01-07-2019, 01:13 PM   #17
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,049
Thanks: 10
Thanked 208 Times in 197 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Magic formula appears

Not sure I follow your meaning based on my testing. I removed 2rd last formula (which appears here as the 3rd last row) and got an automatic result of 33% when I entered values 5, 15 in the last row but data was in the row (60, 5) following before I removed the formula.
75% 8 6
63% 8 5
50% 8 4
50% 8 4

8% 60 5
33% 15 5
Interesting enough, the % autocompletes if you go back and enter values.
No matter. At least we know where the magic comes from.
Micron is offline   Reply With Quote
Old 01-07-2019, 02:25 PM   #18
DanG
Newly Registered User
 
DanG's Avatar
 
Join Date: Nov 2004
Posts: 477
Thanks: 1
Thanked 1 Time in 1 Post
DanG is an unknown quantity at this point
Re: Magic formula appears

Quote:
Originally Posted by Micron View Post
I should have written "in at least 3 of the last 5 preceding rows". I looked it up based on your comments to see if the documentation covers this. Turns out I wasn't recalling it quite correctly. Amazing what missing one word can mean. Might as well post the link as it's for other advanced options as well.
https://support.office.com/en-us/art...6-48b3be0377c4


re your FYI: thanks, but you are too kind, Obi-Wan :-)
I see in your profile you're retired....keep giving answers like this and you'll find yourself working again ....I wouldn't wish that on anyone, thanks again!

__________________
You just pick up a chord, go twang, and you're got music
~ Sid Vicious

I use A03
DanG is offline   Reply With Quote
The Following User Says Thank You to DanG For This Useful Post:
Uncle Gizmo (01-07-2019)
Old 01-07-2019, 10:29 PM   #19
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,049
Thanks: 10
Thanked 208 Times in 197 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Magic formula appears

Quote:
Originally Posted by DanG View Post
I see in your profile you're retired....keep giving answers like this and you'll find yourself working again ....I wouldn't wish that on anyone, thanks again!
Actually, I wouldn't mind being called back to do this sort of stuff. Has happened twice already, but I don't foresee it happening again. Double dipping is not hard to take.
Thanks.

Micron is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Magic Jack Thales750 Other Software 5 03-26-2013 04:21 PM
Bob has worked his magic Brianwarnock The Watercooler 33 11-17-2007 10:22 PM
magic eight ball arkres General 12 10-01-2003 12:03 AM
What is the magic code? Benny Wong Forms 1 11-12-2002 01:26 AM
Magic subforms djh Forms 8 07-20-2000 12:15 AM




All times are GMT -8. The time now is 01:05 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World