All Questions
Tagged with worksheet-function spreadsheet
223
questions
0
votes
2
answers
65
views
How can I create a formula that counts the number of duplicates, returns the value in a cell of my choosing, and then deletes the duplicates?
I've got a list that, after I sort it, looks like this:
rough list
I need a formula that will return the number of times each entry is listed and delete all the duplicates. Typically, I simply count ...
0
votes
1
answer
51
views
How can I combine two Excel formulas into one?
In a spreadsheet, I have five columns (total) and four of them have the components of the students' grade. The fifth has the final grade.
Now, I need to combine two formulas so that when the four ...
0
votes
1
answer
34
views
Count working days between dates
I am seeking a formula that can calculate the number of weekdays between two specified dates, or if the end date is not provided, calculate the number of weekdays from the start date to the current ...
0
votes
1
answer
8k
views
matching names from one Excel Spreadsheet to another
I have two separate spreadsheets, both with several hundreds of employees names. My task at the moment is to go through one of the spreadsheets to see if any employees are matching on both, which will ...
-2
votes
1
answer
91
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 ...
0
votes
0
answers
36
views
Excel SUM function and + operator different for blank text
The + operator in Excel gives an error when adding two cells whose values are empty text, while the SUM function treats these cells as zero (as I expected). I am trying to understand if this is the ...
0
votes
1
answer
46
views
2 problems, complicated copying of data based on a "Number" and dates
The first problem I have is that I have a timestamp in one cell which includes the date and time and I would like to know if there is any automated way to separate them into 2 different columns (Date ...
1
vote
2
answers
11k
views
How can I pull specific rows in Excel into a new spreadsheet
I have several spreadsheets containing data I need to analyse. I have a randomized list of numbers that dictate which rows in each spreadsheet I need to code for my data sample.
Is there a formula I ...
1
vote
1
answer
30
views
How to vlookup all columns and sum
I have two table.
The first table contains menu and price:
Menu
Price
Pizza
20
Pie
10
Beer
5
Burger
10
The second one contains a buyer and menu. I want to get the sum of price based on menu like ...
0
votes
1
answer
70
views
How to count instances of repeated values in a cell range while ignoring blank cells
I have a dataset of subjects (one per row), each with scores taken over several days. Each day has multiple scores, but the number of scores varies such that there are many blank cells.
See a small ...
0
votes
0
answers
26
views
Importing a range of formulas from csv or txt file starts with ' in excel and sheets [duplicate]
I am generating some image URLs with a python script and converting them to a formula. I have tried saving it to both a CSV and a TXT file as others suggested, but both lead to the same problem:
After ...
1
vote
1
answer
69
views
Coloring cells across multiple excel sheets in an xls file based on a condition
I am new to excel. I have an xls file with 10 sheets. In each sheet I have two tables of size 10 x 10, one starting at position A4 and the other starting at N4. All the entries are numbers.
(Note that ...
1
vote
3
answers
18k
views
Display real-time filtering data from another worksheet in Microsoft Excel
I want to display all rows that have a "Gender" column equal to "M" inside "sheet2", where the data is retrieved from "sheet1". The filtered data also has to be ...
0
votes
2
answers
304
views
Get unique IDs with date 1 or date 2. For IDs with both date, obtain row with most recent of the 2 dates
I have been trying to retrieve the row in the following sheet (sheet1) where the dates are matching dates in sheet2 without duplicating the IDs in Sheet1 (Column B)
Sheet1
Sheet2
In other words, I ...
0
votes
1
answer
1k
views
How can I evenly auto-distribute values across 12 columns in a spreadsheet so that their sums are as close to equal as possible?
I'm trying to distribute a bunch of annual recurring business costs across the span of 12 months so as to make each month's total expenditure as close to each other as possible. Doing this manually is ...