Posts by andremundstock • 11 points
4 posts
-
0
votes3
answers4298
viewsA: Count values from one column based on a filter from another column
A simple option would be to create a column B that results in a certain value (zero or one, for example) when a certain condition is satisfied in column A. Then you do the same in column E to…
excelanswered andremundstock 11 -
1
votes2
answers1066
viewsA: Excel: Transpose 5 to 5 cells
A simpler solution would be: In a new document, consider that column "A" is your data and that in columns B onwards the data of A will be organized every five. In B1, B2, B3, B4 and B5 enter the…
-
0
votes2
answers902
viewsA: Excel form (Block fields)
Wouldn’t it be simpler to replace the box with a cell that only accepts options 1, 2 or 3? Below there could be a small table explaining what the 3 options are.
-
-4
votes5
answers7637
viewsA: Is Excel a programming language?
In my opinion YES, a file . xlsx can contain a programming language depending on what it is able to execute. Just look for several scientific articles that feature software developed in Excel (out…