+ Reply to Thread
Results 1 to 2 of 2

What is best to use for helper cells 0 or 1, typed true or false or =true =false

  1. #1
    Registered User
    Join Date
    02-18-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    22

    What is best to use for helper cells 0 or 1, typed true or false or =true =false

    Sorry if it is a bit obscure. I'm pretty good and VBA and Excel but I am a bit stumped as to best practice on the following problem. I wondered if any of my wonderful friends could lend a hand.

    I am building some upgraded dashboards. My old ones are pretty fast even at a 50mb file size.

    I have used helper rows for set time periods and other true false static data. I then use =Sumifs(Total,Range1,True) for example.

    There is a VBA macro that pulls everything in and assigns the static true false data to the columns needed.

    What I want to know is what is faster or best practice for these helper columns.

    Should I go with 0 for false and 1 for true.

    I have a range and a variant array to pop them in then run conditional IF or other code and then deposit the result back in the sheet so I can make pretty charts and graphs.


    Please Login or Register  to view this content.
    Or is it better to go with

    Please Login or Register  to view this content.
    Or is it better to go with

    Please Login or Register  to view this content.
    There is then code to paste the array into the cell. i.e. rng = Arr

    Any ideas as to what would speed up the formulas best?

    Thanks in advance if anyone knows.

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: What is best to use for helper cells 0 or 1, typed true or false or =true =false

    IMHO that little bit of code it probably won't matter. Forum Gurus correct me if I'm wrong but I believe once converted to machine code a Boolean variable requires the fewest bytes of memory. But like I said, at that level it probably won't matter.


    e/ Actually I'm not sure it will matter at all because regardless your variable is declared (explicitly or automatically) as an array so the variable probably requires the same amount of memory no matter which way you set it.
    Last edited by Solus Rankin; 02-20-2014 at 10:45 PM.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] in this TRUE OR FALSE function, i want desired name instead of display true or false
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 06:44 PM
  2. Replies: 3
    Last Post: 07-15-2006, 05:20 AM
  3. [SOLVED] Function to return True/False if all are validated as True by ISNU
    By Tetsuya Oguma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2006, 06:30 AM
  4. [SOLVED] Reverse false and combine with true true value
    By Emmie99 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  5. [SOLVED] Reverse false and combine with true true value
    By Emmie99 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-17-2005, 12:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1