Are you stuck on Excel or Google Sheets?

regression problem have two x variables and do regression analysis but it says i can only have one row or column for data

I need to check multiple cells in an array for a cell value and return value from row containing match ( cell from First column in that row)

I need shorthand to reference the column in the row im working on. For instance instead of writing =SUMIF(Table2[ITEM CODE],B8,Table2[QTY]) I want to write something like =SUMIF(Table2[ITEM CODE],Column(B),Table2[QTY])

We voted for personnel now I am attempting to rank them with different percentages. Column B is worth 40%, Column C is worth 50%, Column D is worth 10% what formula do I use for each column and for the total column in E?

I have 500 numbers in column A with aproximatly 15digits. In column B I have 5 numbers with 6 digits Can a find a formula wich can transfer all numbers from A column wich start with some 6 digitsa from B column

I need to formula to suffix prefix ' (single inverted comma) like 'MITHILA', and comma at the end MITHILA will be in column A and I want result in column B

i want to sum columns c thru k into column l in first line then automatically sum successive columns and lines in columns c thru k as numbers are added so that column l shows running total automatically.

I need to paste date from a column in one sheet and paste it in a row in another sheet. The cells have formulas. Copying then transposing is not working. Please help

I need the column C in ACTIVITY sheet to display only items that have populated fields in the DATA INPUT sheet for each person. Details will be provided!

When I past a line of text into excel, where there is a space, it puts the data in to a separate column. Can you assist?