All Questions
Tagged with worksheet-function spreadsheet
223
questions
1
vote
2
answers
31k
views
How to select and copy entire row based on text-value in a cell in excel
I would like to do the following:
Find all cells containing a certain keyword in a column in an excel spreadsheet.
Select and copy the entire row which includes the cells which have the keyword ...
0
votes
1
answer
125
views
Check row for a specific string and get the value of a column cell where the initial parameter was located
I am trying to create a calendar checker that checks if a value is detected on a specific date and return the month it was detected at:
In the image I am looking for the string "FN" ...
8
votes
4
answers
9k
views
Formula to see if a series of numbers is increasing in value?
I have a spread sheet with thousands of sets of numbers. That is too say, there are ten columns and each column has a number - and there are thousands of rows of these numbers.
What I want to do is ...
0
votes
1
answer
33
views
Excel - The most spending occurred around this date
I feel like as a human I can understand this, but I can't figure out how to get it into an Excel formula.
Given the dates and amounts spent on those dates below, how can I find a date on which the ...
-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
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 ...
0
votes
1
answer
42
views
Adding column description of one spreadsheet sheet in another spreadsheet of same excel
I have an excel sheet having 4 different spreadsheets. I need description of column header of three spreadsheets in 4th spread sheet.
Example:
Suppose I have sheet 1 with 6 headers for 6 columns, ...
9
votes
3
answers
51k
views
Cannot delete created excel table
I have created an excel table. However, I now want to delete or change it because my range changed.
However I can't delete it in the excel Name Manager:
Any suggestion why I cannot delete it?
Would ...
0
votes
0
answers
1k
views
Evaluate function not working
In the example, entering the combined values in K2 as a formula produces the result in J2. J2 is value copied and pasted in J4. To confirm that it is a formula that will not produce an error, the ...
0
votes
1
answer
80
views
Split cell then Vloop then sum
I have a google form linked to a google sheet.
There is one multiple choice checkbox question in the form that asks the user to check A, B, C.
In the google sheet, the answer are concatenated with a ...
0
votes
2
answers
1k
views
Excel Sort Command not working AT ALL as expected
I have a table in excel (formatted as a Table), that does allow me to sort, but its results are incorrect in at least two ways:
the numeric value column I am sorting on A-Z or Highest-to-lowest comes ...
0
votes
1
answer
72
views
Microsoft Excel - How can I convert the following text to 'date' only format?
I have text in a cell with the following syntax: Jan 6, 2022 10:18 AM
The standard format adjustment from 'general' to 'date' does not work. I need to convert the text into a date-only format (ideally ...
2
votes
1
answer
94
views
Change shelves into separate columns
Every day I have an inventory to do. 100 or so items on 15 or so shelves. I also have an xml report that shows what should be available in the room - but this xml does not show what shelves the items ...
0
votes
1
answer
1k
views
How to combine the values from multiple rows in a column (separated by commas) where there are duplicates in another column
I have a large dataset where I want to combine the values of multiple rows in one column where there are duplicates in another column. See my Example below:
CURRENT DATA
Product Type
Email
Product 1
...
1
vote
1
answer
24k
views
How to sum a column based on existance of value in another column
I have the following sheet:
I want a sum of individual spending by Frank, John and Nancy in the yellow cells. Each person's spending is denoted by an x. I tried the SUMIF formula, but I don't know ...