1h
comment If one number then a different number
How is =vlookup not a formula?
1h
comment If one number then a different number
Maybe the question is unclear, but you want to take a number, search for it and return its pair? vlookup.
1h
comment If one number then a different number
What have you tried? How about vlookup?
1h
revised If one number then a different number
added 24 characters in body
Mar
19
awarded  microsoft-excel
Mar
11
comment Can I create an Outlook rule to create a Calendar Alert from Mail message body
Right, that's the attitude you should have on a free site with people offering help to one another. Good luck.
Mar
11
revised Ektron Solr Search Installation - Error: This server does not have the windows authentication role service enabled.
edited tags
Mar
11
revised High CPU using while dragging with brush tool in photoshop cc
edited tags
Mar
11
comment PowerQuery to parse fixed width csv
I've never used powerquery, but what if the csv had delimiters instead of fixed width, would that make it easier?
Mar
11
comment Excel: How to search multiple workbooks for Cell information
So you've found something that does what you want, but also does something else? What have you tried changing? Why? What happens? Where are you stuck?
Mar
11
revised Excel: How to search multiple workbooks for Cell information
added 80 characters in body
Mar
11
answered Use AVERAGEIF across multiple cell ranges in a worksheet
Mar
11
comment Use AVERAGEIF across multiple cell ranges in a worksheet
What is Sheet 1:Sheet 2? You want the same range from both sheets?
Mar
11
comment Can I create an Outlook rule to create a Calendar Alert from Mail message body
Well, what does it do? What does your macro do? What doesn't it do? What is the issue? How can we assist you with a problem that you don't describe? We're not here to write the script for you, we're here to help.
Mar
10
comment How to turn a “many” row-based relation into a “one” column based layout
Transposing would certainly work if I understand your data structure.
Mar
10
comment How to turn a “many” row-based relation into a “one” column based layout
I think the word you're looking for is "transpose" - see if that helps you out.
Mar
10
comment Convert UPPERCASE to PascalCase
Words without an underscore, how would one know what they should be?
Mar
10
comment Drawing independant columns in a pivot table
Pivot chart or pivot table?
Mar
10
revised Create Excel Array In Formula Text
added 12 characters in body
Mar
10
comment Create Excel Array In Formula Text
So what are you trying to do with a 2x2 array as a whole in a function?