All Questions
3
questions
1
vote
0
answers
61
views
In Excel, calculate sum of a column where multiple cells contain specific text
I have a large dataset I'm working with consisting of many records that represent lines on a map. The order heirarchy is State -> County -> Line # -> Line Class -> Line Length. There are multiple ...
0
votes
0
answers
872
views
Splitting excel sheet into multiple sheets based on two columns
I have a table of 10000 rows X 50 columns. The table is all in one sheet and I am planning to split that sheet into multiple sheers based on values in two columns (columns number 5 and 1, ...
-1
votes
2
answers
3k
views
How to have a value from one Excel sheet propagate to other sheets, while being incremented?
I have an Excel workbook, which has 100 sheets in it, all the sheets are identical apart from A10 in every sheet.
In A10 of sheet 1 there is a value 101 which I typed in manually and A10 of all other ...