excel 2010 help

Good day kind sir/madams, im in great need of help. I was given a big file for reporting. My dilemma is that i couldnt figure out a formula to where i can search a cell will multiple text and return it with a title from my list. Below is the image from what im working on. The first cell...

Current version: excel 2010 Hi to all, Currently I am trying to enhance my excel files and do update from main worksheet to duplicated worksheet. I have a main worksheet and a duplicated worksheet. The difference between the 2 worksheet are: Main worksheet has all data (at least 35 columns)...

Hi, Recently I experienced the following behavior in a few of my Excel files: The file may have a simple expression, let's say concatenating columns from a pivot table into another column outside of the pivot table. If I change the expression, the displayed result is from the old expression...

Hi Guys, I am using the below code to save a sheet as a workbook. my query is that when I do run it a notification comes up saying: "parts of this workbook you are trying to save can not be saved macro free : VB Project" I just wondered if there is a way of saving this as a macro free...

I have 3 tables, each has 39 rows and 5 columns. They are located in the same columns (I-M), above each other. (with a few rows in-between, and titles) Each cell in the 3 tables contains either a number from 6-100, to two decimal places or an =NA(). I'm trying to make a new table at the...

Hi All, I'm a newbie to the forum and have limited a understanding of Excel. Currently using excel 2010. My question is around totalling columns across multiple workbooks. Let me break it down more sizeable and understandable format. Data source is in workbooks with names such as ( 2015...

I created a clear stacked bar chart in excel to display Likert scale responses (strongly disagree to strongly agree) for a questionnaire. However, when placing the disagree and strongly disagree values below zero, i still have negative values on the x axis. I want the x axis to display 0-100% on...

My goal: I will have 5 sheets with 5 different sets of data and bins on each sheet. I will also be including a lined scatter plot and a histogram graph of each set of data on each sheet (25 total). I want to only have the histogram chart visible on each sheet (i.e, I don't want my sheet to have...