All Questions
3
questions
2
votes
3
answers
489
views
Getting the value in one column from a formula on another column in excel
I have an excel table that looks like this:
Date Original Actual
11/10/10 15 12
12/10/10 12 10
...
24/10/10 2 1
25/10/10 -2 ...
1
vote
2
answers
98
views
Cover a formula in drop down list with a word
I have a list in Sheet2 J3:J7 of calculated values.
I would like to insert it as a drop down list into Sheet1 B10, which is simple enough, however:
I want the list to use the words: apple (J3), ...
0
votes
2
answers
166
views
How to TEXTJOIN/CONCATENATE based on constraints for specific no of rows count
I need to concatenate certain attribute value based on the sequence number for specific material number and a formula to automate the process.
I have columns as listed in the below screen shot and I ...