Forum Discussion
Filling a form with excel function
Hello everyone. I need help of your's. Can you Please? I have attached an excel sheet for your reference. So please open that and help to resolve my problem mentioned therein
did you open the attachment? I re-created the headers (left and top) and then that formula is in the upper left corner of the grid. The "Data" variable is set to A6:B12 where the original data set is and then the "mains" variable points to J6:L6 where I copied the header row and "Falvours" points to I7:I14 where I copied the left column. "point" those 3 variable to the correct corresponding parts and the formula will do the rest.
You could also use UNIQUE and such to create the header and left column dynamically but was sure you needed/wanted that part.
You could also use UNIQUE and such to create the header and left column dynamically but was sure you needed/wanted that part.
Dear, Thanks a lot for making efforts for me, but I am still unable to calculate that. Because I am beginner in MS Excel and still not able to use complex formulas. So please calculate that at your end and please send me calculated sheet. I will try to learn from the formulas you will fix in my sheet. Please
- thanks
1
