+ Reply to Thread
Results 1 to 10 of 10

Data validation deletes formula - any way around?

  1. 12-10-2019, 01:36 PM #1
    mattyoxford
    mattyoxford is offline
    Registered User
    Join Date
    05-30-2016
    Location
    leicester, UK
    MS-Off Ver
    MS 2015
    Posts
    25

    Data validation deletes formula - any way around?

    hi
    I have on sheet 10 formula which filters out the raw data from fixture tab to show only 'Coalville'
    this information brings across suggested team pitch, and venue,

    ideally, I would like to add data validation/drop down list that can override these selection if we need to , however current set up if time changed just messes everything up

    ive made everything simple, so before anyone asks that the raw data is a mess, the data is pulled across from the league websites like this; hence why a separate formula filter was thought on

    the end user has basical knowledge of excel, hence didnt want together into filters, and editing raw data etc

    any help ?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-11-2019, 08:02 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Data validation deletes formula - any way around?

    That person was me!! Did you evaluate the formula in your previous thread? Did it work or not? Some feedback is always appreciated.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 12-11-2019, 10:53 AM #3
    mattyoxford
    mattyoxford is offline
    Registered User
    Join Date
    05-30-2016
    Location
    leicester, UK
    MS-Off Ver
    MS 2015
    Posts
    25

    Re: Data validation deletes formula - any way around?

    hi glen,
    it looks messy as sometimes the fixtures per age group increase hence few spaces in between


    did you get what I meant about drop down list in this topic
    Reply With QuoteRegister To Reply
  4. 12-11-2019, 10:57 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Data validation deletes formula - any way around?

    No. Not yet. I was waiting for you to close out your previous thread which I replied to. You never provided any feedback on whether it worked/didn't work/was a complete misunderstanding of your problem....

    Some feedback helps!!
    Reply With QuoteRegister To Reply
  5. 12-11-2019, 02:24 PM #5
    mattyoxford
    mattyoxford is offline
    Registered User
    Join Date
    05-30-2016
    Location
    leicester, UK
    MS-Off Ver
    MS 2015
    Posts
    25

    Re: Data validation deletes formula - any way around?

    feedback done FYI
    Reply With QuoteRegister To Reply
  6. 12-12-2019, 04:36 AM #6
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Data validation deletes formula - any way around?

    Your file is non-functional. The formula in 10 looks like this:

    =IFERROR(__xludf.DUMMYFUNCTION("FILTER(Fixtures!D2:J1500,ISNUMBER(SEARCH(""Coalville"",Fixtures!D2:D1500)))"),"Coalville Town Ravenettes U8 Ravenettes")

    I have no idea what __xludfDUMMYFUNCTION is doing. The DDs in the yellow bit seem to function as expected.
    Reply With QuoteRegister To Reply
  7. 12-12-2019, 10:50 AM #7
    mattyoxford
    mattyoxford is offline
    Registered User
    Join Date
    05-30-2016
    Location
    leicester, UK
    MS-Off Ver
    MS 2015
    Posts
    25
    Hi
    The highlighted yellow

    I wanted a vlookup that brings the result back but if we need to change
    For example a kick off or venue then use of a drop down list
    However when you do this it deletes the formula of the vlookup
    Last edited by AliGW; 12-13-2019 at 05:47 AM. Reason: Please don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  8. 12-12-2019, 11:03 AM #8
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Data validation deletes formula - any way around?

    It will do. You can not have a formula and a value in a cell. Not without VBA.
    Reply With QuoteRegister To Reply
  9. 12-12-2019, 12:25 PM #9
    mattyoxford
    mattyoxford is offline
    Registered User
    Join Date
    05-30-2016
    Location
    leicester, UK
    MS-Off Ver
    MS 2015
    Posts
    25

    Re: Data validation deletes formula - any way around?

    any there suggestion,

    I want the pitch, time and venue to return there default, however with the option to override.
    however when we update the fixtures tab- this is done automatically
    Reply With QuoteRegister To Reply
  10. 12-13-2019, 05:31 AM #10
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Data validation deletes formula - any way around?

    It cannot be done. You would have to change it in the raw data. As I said, you can have a value, or a formula in a cell - not both.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] running macro deletes data
    By OldLadyStillLearning in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-01-2023, 01:28 AM
  2. Is there a formula or function that deletes a set of words?
    By jtmann in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-16-2017, 10:45 AM
  3. Help with vba code that deletes all data except for highest value
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2014, 06:01 PM
  4. Formula Deletes upon Clearing data from cells
    By ebner20 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-23-2013, 09:12 PM
  5. Formula Deletes upon Clearing data from cells
    By ebner20 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-23-2013, 12:09 AM
  6. Formula Required Which Deletes Certain Text From Cell If Certain Terms Appear In Row
    By Greenal in forum Excel General
    Replies: 6
    Last Post: 08-22-2011, 09:50 AM
  7. Autofilter Deletes Not Just Segmented Data
    By cnelson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2008, 04:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1