• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. G

    Calculate standard deviation across multiple sheets with partial match

    Thanks P45cal If I remove #N/A from being in my data then what would your cell formula be? I can filter my data to prevent #N/A from being present. I am curious to these creative solutions. (After seeing what excel can do on this forum, I am impressed with Excel!!) Regards and thanks in...
  2. G

    How to sample data 1 time and permanently store in a cell without using VBA?

    Got it. Thanks for reply I will add sample file and repost in VBA section
  3. G

    Calculate standard deviation across multiple sheets with partial match

    Hello I want to calculate standard deviation across multiple sheets on negative data only. Data range is c9:j9 on both sheets Aggregate1 and Aggregate2. When there is a partial match in range c9 to j9 for negative numbers, calculate std dev for negative numbers only on both sheets. Ignore...
  4. G

    How to sample data 1 time and permanently store in a cell without using VBA?

    How would I implement my original problem above in VBA? (Sorry for delay. I am back to this project) If I have RTD() function in a row for 365 columns (1 years worth). Each column would represent a day. I want to turn on one column at a time. I can use an enable bit like in cell B2 to enable...
  5. G

    How to sample data 1 time and permanently store in a cell without using VBA?

    -- Thanks p45cal for response Can I automate the process in a formula? I need to do it across 300 cells. I was thinking about converting it to text with text function.
  6. G

    How to sample data 1 time and permanently store in a cell without using VBA?

    I am using an Excel Real Time Function, =RTD(), which will constantly update when another program is active at the same time. RTD will not work without the other program. I want to grab the end of the day data for storage but the =RTD() function is constantly updating. 2 Questions 1. Without...
  7. G

    How to get average across sheets with #N/A in data?

    Thanks pecoflyer! It works now.
  8. G

    How to get average across sheets with #N/A in data?

    Hello How to get the average() function to work across sheets with #N/A in data? The result is in sheet cc3 and data are in sheets aa1 and bb2. The data is in non contiguous cells, one cell ranges. See attached file. Regards Tony
Back
Top