Posts by Marcelo • 107 points
5 posts
-
-1
votes1
answer42
viewsQ: How to make a "hierarchical conditional formatting" in Excel 2010?
i need to program a "hierarchical conditional formatting" in Excel 2010, based on two entries: the cell format on the left and whether the value belongs to a given range or not. To understand better…
-
0
votes1
answer276
viewsQ: How to save an Excel spreadsheet from R without blank lines?
I’m working with a large database and it has a few lines with blank Ids. And I want to save only lines without blank ID in an Excel file. Whereas the Ids are in the first column of my matrix, here’s…
-
4
votes1
answer1069
viewsQ: How to merge multiple Excel spreadsheets into one?
I have a set of worksheets (for example, suppose they are called file01.xls, file02.xls, file03.xls etc.), all with the same columns in the Sheet1 tab and with the other empty tabs. How do I join…
-
4
votes2
answers897
viewsQ: Is there an Excel function that associates letters with numbers (A = 1, B = 2, C = 3 etc.)?
Is there any Excel function that associates letters to numbers according to alphabetical order (ie, f(A) = 1, f(B) = 2, f(C) = 3 and so on)?
-
2
votes2
answers126
viewsQ: Is there any Excel function that returns the body of another function?
Simple example of what I want: suppose in cell A1 I have value 2, in cell A2 I have value 3 and in cell A3 I have formula =A1+A2. If I put in cell A4 the formula =A3, it will obviously return me the…