All Questions
105
questions
0
votes
2
answers
554
views
How to conditional format ONLY the first row that meets a condition?
I have an amortization table with a date next to each row. How do I highlight ONLY the first row that is a larger date than today's date?
Let's say the date column starts at A13. Obviously this...
=...
- 103
2
votes
1
answer
63
views
I want to make new column with Logic?
Given: Employee ID and Manager ID.
| Employee ID | Manager ID |
|:-----------:|:----------:|
| E068 | E067 |
| E071 | E067 |
| E229 | E069 |
| E248 | ...
- 171
0
votes
1
answer
516
views
I want to GROUPBY in Excel
I have two column Code and Score. Like this
| Code | Score |
|:----:|:-----:|
| M01 | 4 |
| M05 | 3 |
| M02 | 4 |
| M01 | 5 |
| M04 | 4 |
| M01 | 3 |
I want to get the ...
- 171
3
votes
2
answers
87
views
I want to count IF both condition are true Logically count by AND excel
I have two Columns both are categorical columns. Like Age_group and Engagement_category.
And I want to get count no. of each engagement_category in each Age_group.
| Engagement_category | Age_group |
...
- 171
0
votes
1
answer
1k
views
How to add 'filler' characters up to N limit to a variable length string using Excel / Sheets formulae?
I have a list of strings (names / description text) that I need to add 'filler' characters to.
The maximum string length is 32 - for any text under that (in characters) I need to add special filler ...
1
vote
0
answers
75
views
How could I create a filter custom formula that returns a match for cells CONTAINING a word/phrase OR another word/phrase?
I'd like to create a filter using a custom formula that will display only cells that contain the word "Red" or "Blue" (as an example) as part of a longer string. These words are mutually exclusive so ...
- 111
13
votes
3
answers
25k
views
How do I append a character to the end of every line in an Excel cell?
I have a column of Excel cells that's similar to a grocery shopping list and looks as follows:
3 Days Ingredients
2 Apples
1 Jug of milk
3 Bags of mixed vegetables
5 Potatoes
Is there a way to ...
- 241
1
vote
2
answers
132
views
Advanced F&R Regex - Sheets / Excel - If "X" is in cell A1 and add "Y" to cell B1
I am looking for a formula or regex that I can use to find a value in a string in one cell and if found add another string to the adjacent cell in another column.
For example, I have a list of ...
0
votes
1
answer
134
views
How to vlookup/hlookup in microsoft excel?
I have a relatively simple formula that I can not figure out.
I need to use B1 and B6 to return a value in B7.
B1 needs to match the value in row 12. Then using only that column of the matched value, ...
- 3
0
votes
0
answers
76
views
Count number of rows based on multiple criteria
I have a sheet used to calculate work-time for contractors and catch errors. Each row is a time-entry, with columns used to indicate the employee name, campus visited, date, time-in, and time-out.
I'...
- 1
0
votes
1
answer
81
views
spreadsheet formula for returning parts of filtered cells in column
I use Libreoffice. (If Excel or GoogleSpreadsheets would be the only way to get a solution, I would be willing to switch. But the preferred platform is LibreOffice, I'm looking for a solution on this ...
- 157
0
votes
1
answer
69
views
How to sort based on excel or sheets column data
I have a form that submits to a google sheet with the following columns:
Entry Date, First Name, Last Name, Address, Phone, Email, Member Type, Vote Date, Result
(The 'result' column has three ...
0
votes
0
answers
2k
views
split sentences from paragraph into individual cells
I have text data that I want to parse. The data is split into cells but each cell contains more that just one sentence. I want to isolate the sentences into individual cells to make parsing easier.
I ...
-1
votes
1
answer
2k
views
Concatenate cells but exclude 'empties' in Excel/Google Sheets with line breaks
I'm trying to figure out how to concentrate data in list form(line breaks) that would exclude blank cells (when not filled in our when filled in auto populate). I received the below formula, however ...
0
votes
1
answer
2k
views
Concatenate cells but exclude empties in Excel/google Sheets
This is regarding post:
Concatenate cells but exclude empties in Excel
With the below formula, we can have data concatenated by comma's, is there a way to add CHAR(10) to have the data from the 'A,B ...