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...
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...
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...
--
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.
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...
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