More Excel Answers
Question Library
Ask a question about Excel
Volunteer
Experts of the Month
Expert Login
Awards
About Us
Tell friends
Link to Us
Disclaimer
|
| |
|
|
| |
| | | |
About Bill Hermanson
Expertise
Please tell me WHICH EXCEL VERSION you are using!
DO NOT ASK ME me about Macros or VBA.
Please read my "instructions to questioners" in my full profile [use View Profile, at right], to help you write a question that I can understand, without having to ask you what you mean.
If your question contains any of the words THIS, IT, THAT, THOSE, or THEY, I likely won't understand IT. Please rewrite!
My Expertise: I am an expert at data manipulation, the use of incredibly complex logical statements, databases, combining tables and extracting data, all the LOGICAL, LOOKUP & REFERENCE functions, dynamic ranges, creating professional appearing spreadsheets, complex functions, integrated charts and visual displays, user interfaces.... I can make Excel do anything!
But PLEASE... NO MACRO or VBA QUESTIONS!
Experience
25 years development of complex spreadsheets for personal and professional use. I've developed hundreds (or thousands!) of spreadsheets in all fields, from complex engineering calculations to game scoring, financial analysis, scheduling, cost-of-doing-business, and analysis of home energy use. I even used Excel to assist in design of the flight computers presently on board the Hubble Space Telescope (1984-1991)
Education/Credentials
BSEE Electrical Engineering, CU Boulder CO USA
Use of spreadsheets since 1982
Boulder Valley School District, Life Long Learning, Instructor
Owner & Operator of Excel Expert, LLC
| | |
| |
You are here: Experts > Computing/Technology > Microsoft Software > Excel > Filling blank cells according to specified weighting
Excel - Filling blank cells according to specified weighting
Expert: Bill Hermanson - 11/5/2009
Question
Hi Bill, I was hoping you could help.
I am looking for a formula that will fill blank ‘result’ cells with the data from the ‘input’ cells according to a weighting supplied alongside the input cells.
For example, if in cell A1 I have the entry “Heads” and in B1 I have the number 7, and in A2 I have the entry “Tails” and in B2 I have the number 3, I would like D1 to D7 to all show “Heads” and D8 – D10 to all show “Tails”.
The example I have given above is obviously quite simplified. The data I will be working with will add up to 100 (rather than 10) and the number of ‘Input’ cells is likely to vary – so the formula would hopefully work just as happily with Heads and Tails as it would with Red, Orange, Yellow, Green and Blue.
Although I am happy with basic IF functions, this is a little out of my league. Any help would be greatly appreciated, even just a prod towards the functions I should be looking at.
Many thanks.
Answer
Rob,
I have the impression that once you have this column of heads and tails, you are going to do something else with it... some other calculation that you didn't identify.
It may not be necessary to create this column of Heads and tails at all, and if I knew what you were going to do with it next, I could advise you how to skip this step.
I suggest this because, creating the column of head and tails isn't easy, at least no simple solution has sprung to mind.
I'd also suggest that you ONLY gave an EXAMPLE, and never actually stated what it's an example OF. You mention a 'weighting', but it seems more to me like a count. You may have oversimplified your question to the point where the solution I might offer would be too simple to work for what you're really trying to do. So, why not give a more detailed explanation of where you're going with this, and let me help with the overall problem, instead of this little tiny piece?
>>> Bill
Add to this Answer Ask a Question
|
|
