Reputation
6,382
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 8 23
Newest
 Yearling
Impact
~474k people reached

2d
comment Get a value from the most recent previous record where some text appears in either of two columns
It would help to see the data structure. Can you post a sample file? Think file sharing service.
May
1
comment How to update a third column from a column when two other columns match?
Start Excel. Mock up your scenario with all columns. Manually input the desired results. Take a screenshot and post it to a file sharing site. Post the link. Then your question might make some sense.
Apr
30
answered Excel - Dynamic Cell Update using multiple criterias
Apr
27
comment Excel data validation to whole column
@AllSolutions, what part are you struggling with? Insert a table. Apply the data validation to the table column. It will carry over into new rows.
Apr
24
comment Column of text needs “summed” based on assigned value
Thanks for the feedback. Glad it worked for you.
Apr
24
comment Column of text needs “summed” based on assigned value
You're funny. Let me know if it works or if you need more guidance.
Apr
24
revised Column of text needs “summed” based on assigned value
added 8 characters in body
Apr
24
answered Column of text needs “summed” based on assigned value
Apr
23
comment Excel data validation to whole column
@AllSolutions, All formats, formulas and data validation that are applied to an Excel table column will be carried over into new rows.
Apr
22
comment Automate spreadsheet (Excel/CSV) workflow
The question asks for a tool or process. Answers may well include code or data management techniques, not just products. As it happens, the Microsoft Power BI stack has a suitable approach. Power Query will not go away any time soon.
Apr
22
answered Automate spreadsheet (Excel/CSV) workflow
Apr
22
comment Add a cell content to another cell if a different cell has a specific content
Please learn how this site works. No, you cannot tack on more questions in comments. Please mark the answer. Then start a new question.
Apr
21
comment How to highlight where a number in another cell falls in a column? Bracket it with the next highest and next lowest?
Well, as far as I understand you want to highlight the range BETWEEN which the value falls. 5000 is not between any of the values, so nothing gets highlighted.
Apr
21
answered How to highlight where a number in another cell falls in a column? Bracket it with the next highest and next lowest?
Apr
20
comment Powerpivot, Calculate(SUM()) with OR Statement?
Sum the column and use filters in the pivot table, not in the measure.
Apr
20
comment How to highlight where a number in another cell falls in a column? Bracket it with the next highest and next lowest?
How do you want this to look? What is the expected result with your data sample? Highlight what? How?
Apr
20
comment Add a cell content to another cell if a different cell has a specific content
I edited my answer. It's really the same formula, just using different columns and a different row for the sum range.
Apr
20
revised Add a cell content to another cell if a different cell has a specific content
added 330 characters in body
Apr
20
comment I am trying to use the if function to look at cells to the left and leave the cell blank if they are blank or calculate if they are not
I edited my answer with a few more suggestions.
Apr
20
revised I am trying to use the if function to look at cells to the left and leave the cell blank if they are blank or calculate if they are not
added 320 characters in body