Hello,
I'm trying to figure out how to use the is number function in numbers. Here is a formula that works in excel =IF(ISNUMBER(RowNumber),INDEX(Table4[Element],RowNumber),"")
I need a numbers formula that works to reference column Q in the formula table and then index (Table 5::$D$1:$D243), Column Q
Here are the screen shots from excel
MacBook Air, OS X El Capitan (10.11.6)
No need to apologize. 🙂 There was some contribution to the other thread that seems unresolved, though. Rather than try to hack a solution using a workaround for a formula that Numbers doesn't support, why not have a look at filtering? Filtering very convenient and powerful, both in Excel and Numbers, and can save a lot of time trying to get complicated formulas to do what you want.
Filtering won't work well if you need fully automatic second-by-second updating of your data. But for most other purposes, including what I think you are trying to do here, it can be a very efficient approach, well worth trying.
SG
Hi SG,
I now have a chart question. I'm going to have two different kinds of pie charts.
One pie chart is for individual formulas. The formulas are listed in Column A and consist of different Herb combinations listed in Column F. Bai He Di Huang Tang's formula information is in Row 3A - 4IS. There are different Categories that I need to have represented in a pie chart like 3T - 4Y. I want a pie chart that represents all of the information in 3T - 4Y without putting a sum total of that section. The reason I don't want to put a total of each Formula section is because my second pie chart will be a sum total of every formula. So for that Pie chart I will use the sum total function listed in U12 - Y12.
Any help would be appreciated. Thanks
Why are you double-posting? Is this different from what you started in your other thread? If so, how is it different?
SG
SG,
I apologize if I have offended you in any way or have inconvenienced the way the forum works. I was assuming since it was a different approach than was replied to I would post it in a new thread. That being said, I understand that you are advising that this is not correct. Again, I apologize and will pay more attention.
I looked at the filtering option and from what I gather will not work for what I need. The spreadsheet has 250 columns and about 1000 rows. I will be creating different pie charts based on the information in the columns and rows.
From what I gather the filtering option will not fill the cell and even if it does I’d rather find a way to have it auto filled through a formula. Even if filtering does fill the cell it would be incredibly labor intensive to do it that way.
The issues comes in with inputing the information into the cells. It would take an inordinate amount of time to fill in all the appropriate cells. I guess I could copy and paste but that would also take a lot of time. I really want to capitalize on what a formula can do.
Thanks Wayne,
That test seems to work. Now I can't seem to get the rest of formula to work. Any thoughts?
Shadedlight wrote:
I looked at the filtering option and from what I gather will not work for what I need. The spreadsheet has 250 columns and about 1000 rows. I will be creating different pie charts based on the information in the columns and rows.
If you want to create charts based on a data table containing some 1000 rows of data, rather than moving parts of the data to other tables, have you considered setting up summary tables based on the data, and charting those summary tables? That is the typical way one would approach this kind of problem in Numbers.
In the summary tables one typically uses SUMIFS and COUNTIFS to automatically extract subtotals and subcounts that can be charted. More on SUMIFS here. More on COUNTIFS here.
SG
Number does not have that function. The test you can use instead is:
formula in cell B1 is:
=OR(IFERROR(ISEVEN(A1), "FALSE"), IFERROR(ISODD(A1), "FALSE"))
Hi SG,
Here's the formula that finally worked perfectly for me.
IF($Row Number≠"",INDEX(Table 5::$D1:$D243,$Row Number,column-index,area-index),"")
is number function
