2
votes
Is it possible to make this formula more automated?
It looks like your table headers are a combination of the [metric] and [class] values from your RawData table. You could probably make things easier on yourself by using a single delimiter, such as a &...
- 86
2
votes
Is it possible to make this formula more automated?
This seems to be an issue with incompatible datatypes in the RawData[class]=1 part.
Presumably class in RawData is a number (no way to know, as you didn't include any data).
When you write 1 yourself, ...
- 5,555
2
votes
Excel: Unique with Filter formula for Blank and " " cells still returns an empty value from list
The syntax for the FILTER function is as follows:
=FILTER(array, include, [if_empty])
It appears as though you have incorrectly attempted to write a second include condition in the [if_empty] ...
- 86
2
votes
Keep trailing zero's in excel formulas
To format values for display (without actual change to the value) you can use e.g:
="The value is: " & TEXT(A1,"0.00") & " millimeters."
Where "0.00" ...
- 8,818
1
vote
Is it possible to make this formula more automated?
Update
After messing with it for awhile this morning, I wasn't able to get the formula to work correctly using exact responses I got—I still keep getting incorrect data when filling the cell across ...
- 25
1
vote
How to get the value from a cell given a name box in Excel
The problem you are having is related to your layout of two rows sourcing data from one.
With some flexibility in your layout it would be 2 cell copied as many as you want.
It seems that you source ...
1
vote
Accepted
Power Query: Refer to a Column by Name Stored as a Text Parameter (REDUX)
You need to pass the parameter as a text string, so try:
#"Filtered Rows" = Table.SelectRows(#"Changed Type", (r)=>Record.Field(r,FilterColumn)<>null)
or
#"Filtered ...
- 8,233
Only top scored, non community-wiki answers of a minimum length are eligible