All Questions
Tagged with worksheet-function spreadsheet
223
questions
-1
votes
2
answers
73
views
copy worksheet to several workbook
I created a worksheet/spreadsheet with functions and references to cells in other worksheets/spreadsheets within same workbook to create a report of other worksheets within the same workbook.
I have ...
-1
votes
2
answers
29k
views
How do I split single cell contents into multiple columns without seperators?
I have an excel spreadsheet that has the following:
Cell A1 ABCD 1234
I would like to split this to be
CELL A1: ABCD
CELL B1: A
CELL C1: B
CELL D1: C
CELL E1: D
I tried using the text ...
-1
votes
1
answer
5k
views
How to automatically update all the relevant cells in Excel when a new row is added
So I have a spreadsheet used for calculating let's say the taxes on something which I purchased. It has a column with the sales tax calculation, state tax, etc. and all each of these columns reference ...
-1
votes
1
answer
2k
views
Share cost of activities between participants in spreadsheet
Say you have a spreadsheet you use to fairly share the cost of activities between people (example google doc):
A B C D E
1 Activity Cost User1 User2 User3
2 1 ...
-1
votes
1
answer
647
views
How to get data from separate worksheets displayed in a single separate worksheet
I am working on a spreadsheet in Microsoft excel 2010. In the spreadsheet I have 3 worksheets. These are known as:
1st
2nd
Cases
Now in the 1st and 2nd Worksheets, there is a table at the bottom ...
-1
votes
1
answer
582
views
Excel: How to count how many times a consecutive text value appears
I'm making a work schedule and I have to pay attention to a specific rule that, no worker should be scheduled to work more than 6 days in a row.
I got this spreadsheet where I make those schedules but ...
-1
votes
3
answers
2k
views
Excel: How To Transpose Every Random amount of N Rows From One Column To Multiple Columns?
I have a set of multiple choices questions with ABCD as answers, all answers are stacked on a column, but not every question has the same amount of answers.
Instead of transposing every nth value, my ...
-1
votes
1
answer
4k
views
How to automatically create multiple sheets on Google Sheets?
I have one sheet (Sheet1) which I consider the template. In it I have a header with fields like "Student's name", "Parent" and "Phone number", which are personal info. Bellow it there's other stuff ...
-1
votes
1
answer
76
views
Copy cells from one excel spreadsheet to another based on a value in the row
I have a spreadsheet, Sheet 1, with data in it taken by the minute. Each line row has a timestamp and the corrosponding data follows.
I have a second spreadsheet/sheet, Sheet 2, with accompanying ...
-2
votes
3
answers
119
views
Excel Lookup In Table [closed]
I am trying to lookup a value in a table based on the row and column headers (bolded).
For example, I have a table:
-2
votes
1
answer
92
views
How to count occurrences of rows that have certain value only if preceding by certain value, and count how many rows of that
I have some data spread over one column and 120 rows
there is a repetition of the value 1 and 0 corresponding to certain operation mode
so it looks as per the image attached
My question is how to ...
-2
votes
1
answer
1k
views
How to update item quantity in excel?
I don't know much about Excel or spread sheets to be honest. But my girlfriend has been working on updating item quantities for the past two days. There are over 500 items.
Basically what she needs ...
-7
votes
1
answer
76
views
URGENT =IF(C3>37.6,"high"), IF(C3<36.6,"low"),IF(AND(C3>36.7,C3<37.5,"normal"))) is this formula right
The second half of the formula doesn't work If body temperature of patient (t) < 36,6, it is low, from 36,7 to
37,5 - normal, greater than 37,6 - high.
This is the information to create the ...