Share your Knowledge of Excel and help others!

Think you can assist answering some of the questions received at Excel Geek?  Then why not become a contributor to the website and help share your knowledge of Excel!  All help is gratefully received!

You don’t need to be an expert to answer questions.  If you’ve had experience of a particular problem and found a solution then share it with other people.

Below are some of the latest questions submitted to the site…

Thank you  :-)

Clerk

Hi, I usually use 5 Workbooks (Week-1,Wee-2,Week-3,Week-4 and Master) but for this example lets use “Week-1” and “Master” workbooks. I currently …

Data Analysis

I have a situation where I have 3 different “categories” but 4 differernt formulas. SO, let’s say my categories are Dogs, Cats, and Fish. I will always have …

Tricky Question

Hi, Not sure how best to explain this but here goes: I need to marry two sheets, the one sheet has the names of the customers and billed amount (Sheet 1) and the other has the …

Pivotstyle modify – totals

We use modified pivot tabel syles – does the grand total format always override the row subtotal formats or can I change where they overlap?  Youc an see my problem …

Help with SUMIFS – excel 2007

Hi,   This is my formula its currently pulling volume information by period from a workbook into this workbook, I need add another level to say just bring just a certain …

Manager

Attatched is an example of what I am working on. I am trying to figure out(in VBA) how to sum TrksReq in column B based on plant number in column A. The sum must appear in the …

Computer Teacher

I am working with a listing of 10 and for each I have 6 columns – last name, first name, SS#, Salary, Date of Hire, Department. I want to create reports from this …

Conditional Formatting (cell colour – 3 tier) Based on value of one cell and date in another

Hi Ladies & Gents I’m hopeless at anything beyond the very basic formula and would like help with the following if poss please: I have a huge accounting spreadsheet with …

How to increase a number from a text and number combine cell ?

How to increase a number from a text and number combine cell ?   In column A I have several kinds of codes which are duplicate. Now I want to make anothere code usith those …

complicated if function

  Dear Excelgeek, I need your help to make formula for my study, here is the result table:   Male Result Age Very Good Good Fair Poor Very Poor 10 04:47 04:48 05:49 …

If Cell Value equals “X”, then enter descrition and price in adjacent cells

I have eight different product numbers with unique descriptions and prices. In order to reduce or eliminate order entry errors, I would like write a formula that when one of the …

SUM of Highlighted Cells

/* Style Definitions */ table.MsoNormalTable {mso-style-name:”Table Normal”; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; …

Как оформить спальню в стиле прованс? Фото дизайна красивых интерьеров, выбор штор для спальни прованс, люстры, мебели, элементов декора, цвета обоев

Ассоциируется с бездной, холодом, космосом, пространством так.By:

Data pattern?

I am trying to create a pattern in excel, all in one column..ie. Notice the pattern below. I want to automatically continue this pattern all the way to 600…   I hope …

Count Row data based on a column

Hello –    I have a spreadsheet of data (Excel 2016) analyzing newsletter results for our firm. Column A has client email addresses and each column to the right …

Excel Speadsheet

What does it mean when your speadsheet shows Sheet1(4) on the bottom??? What does the (4) mean?? and how do I get rid of?? By:

Tracking Document Log

I want to track document log where I want to get Auto update of Status as “OPEN” or “CLOSED” by inserting document submission date and document response …

Data Analyist

I have two Columns In column A: Athere is date In column B:B There are events that will occur on the date which  is in A:A   Now I just want get get formula that will …

Selecting Multiple filters for two separate tables

Hello,   I have two individual tables on the same spreadsheet. I would like to use multiple filters from both tables, however every time i select the second filter, it resets …

Countif match specific day

the data: 9/1 9/2 9/3 9/4 ~> 9/30 group b x x x x x group b x x x x x group a x y x x y      group c x y y y y group c x y y y y group b x x x x x group c x …

data analysing graphs from excel

hi, i have a question at excel. if you can help me?? i need to do data analysing graphs from excel, and they look more or the less the same like this one. and i want to separate …