I receive orders for telephone service for between 15 and 30 stores in a single email in regular text format. The stores are separated in the email by one blank line. Each store begins with ...
The following formula works in Excel but not in Google Spreadsheet: =INDEX(Sheet1!B1:P1,MATCH(MAXA(Sheet1!B11:P11), Sheet1!B11:P11,0)) Would there be alternatives? Thanks, Bing
In a spreadsheet (Excel, Google Docs, OpenOffice), how do I transpose data from rows to columns, but only non-null cells?
I work with all three spreadsheet programs listed above, and I believe my question can be answered the same or similarly for all three. On my sheet, I have a top row full of column headers. The ...