Column Consolidation
I have two columns, one with a name and one with an item. There are sometimes multiple names for the same item and multiple names with different items. I am …
How to devide the value, based on drop down choices
Hello, I am looking to find a way to divide certain value based on the drop down choices in excel. What I am trying to do is to make a way to …
SUMIFS populate cell with value
I am using Windows 7 with Excel 2010. I need a to populate a cell in one worksheet with values from another worksheet using the following criteria. This is for …
Excel Formula for calculating a grade
I want to create a cel that calculates a “participation” grade for a 2 hr class. I have a group of cells to record atendance: AO:BN. If the student …
Reformatting data and columns from vertical to horizontal
hello guys, i need to arrange my excel data’s from this https://www.opendrive.com/file/NF8xNjUxMzY2MjBfanRtOWc to this …
Problem in opening an Excel 13 Macro Enabled Workbook in Excel 10
I have designed a Macro Enabled workbook in Excel 13. The workbook contains Userforms, Commandbuttons, Checkboxes and other macro functionalities. These are …
Create multi-select drop-down based on another multi-select drop down
I am hoping someone can help me. I have a multi-select drop-down in one of my columns in excel. The user can select and de-select values from a list of 12 …
Excel add total of entries separated by a + sign in a formula?
I’d like cell E433 to total the amount of entries entered into a formula in cell F433 where the formula is: =91.72+38+292.45+38.4+81.23+43.52. …
Deleting excess rows in a table when copying over information
At my job I work with large amounts of data. I have an Excel spreadsheets with tables that contain all of my necessary formulas and fuctions, but I frequently …
Excel 2010 ‘IF’ Formula trouble
In my highlighted cell I want to say:- If K25 has the letter G in and M25 has the letter G in and O25 has the letter G in then my highlighted cell would be G. …
Automatically update data in two different sheets?
Hi everyone! Since yesterday, I got stuck with a problem, and surfed the entire www, looking for an answer, but no succes. Long story short, I have …
Consultant
I am using Excel 2010 on a Win7 PC. I created a pivot table based on a fairly small data set, combination of text, formulas, percentages, numbers, …