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  :-)

Pull project title if it falls between two dates

Hi,    I got this table right here in Sheet1: A                   B              …

Compare everything against everything

Using Excel 2016, how do I compare every row to every other row, and see which are most/least similar? Example: 4 rows with 6 numbers each in them.   2 4 98 7 3 2 6 4 .5 1 .4 …

Forecasting the size of an order funnel based on new orders and ones that complete out

I am trying to forcast a the size of an agent’s funnel of orders based on the following criteria: I know that:  – Each agent will be assigned around 105 new …

Excel Bug?

I have an Excel dashboard (no VBA) that connects to external platform and via some DLLs displays live data into the cells. Many people are using this dashboard (over 100) and …

Director of Operations

I need to return a value from a specific cell, based on whether a date in another cell is 1 year, 2 years, 3 years, 4 years, or 5 years older than today’s date [using …

Excel 2016: Sumifs Conditions

  How to add a date match as an AND condition to sum, when the values are horizontal/rows and are not equal. They do not match in size criteria; which is required for the …

Linking charts to other workbooks

I would like to link a chart from one Excel workbook to another. However, the chart formatting (chart titles, colour, chart type) is not included in the link. The values change …

Unique values in a range on multiple sheets

I am using Excel in Office 365 and cannot figure out how to get a total of how many unique numbers are in B20:B200 on four sheets (FY19Q1, FY19Q2, FY19Q3, FY19Q4).     …

Excel formula question

Hi, looking for help. I have created a drop down list with a number of short patters. What I am now looking for is for a selected shift pattern to automatically populate a cell …

Excel formula question

Hi, looking for help. I have created a drop down list with a number of short patters. What I am now looking for is for a selected shift pattern to automatically populate a cell …

Complex formula help needed

Scenario:  Column A is a list of products (30 lines) Each product is assigned a value in Column B (either “Exclude” or “Include”) I need to create a …

Systems operations

Hi, I was wondering if you can please help me. I have an excel 2010 spreadsheet which derived from Active Directory (report). I need to find out how many user accounts we have …

Calculating costs / cumulative costs

Hi there, I’m looking for some help as I’m not really sure of the correct terms to use on my query below, so whilst normally I would google this, I’m not …

Division Consultant

  In our computer system, we have different codes for everyday tasks.  Problem is the codes are different for each division we have. For Example: East Division codes for …

Unable to search ClickToRun using VBA

Hi, I am trying to find ClickToRun folder in registry using VBA. If I search the folder manually, I am able to find it. But if I use VBA code, it cant locate the folder. I tried …

Enter a letter code in one cell and represented number in another cell

I will do my best to explain what I’m looking for – I hope it makes sense! I have included a bit of my worksheet so you can hopefully understand easier. As you can see …

EXCEL MATCH EXACT 3 VALUES FROM 4 COLUMN

I WANT TO KNOW ABOUT EXCEL FORMULA WHICH CAN GET 3 (THREE) EXACT VALUES MATCH OUTPUT FROM OUT OF 4 COLUMS.  EXAMPLE – EXCEL SCREEN ATTACHED.     A B C D E 1 …

Excel “IF” formula help

hi i need to know if i want to enter a certain word in a cell and i need a value for that word in numerical digita in another cell, then what formula would i have to apply? By: …

how to select certain cells in excel VBA CODE

how to select certain cells in excel VBA CODE for ex: “B2:B16384,C3:C16384,D4:D16384,E5:E16384,F6:F16384 TO XFD16384:XFD16384” Like decrease cell value …

Excel Compare and Return Result

Hi,   I have a set of field to compare in 2 different spreadsheet out of which any match will then check and return for a specific value in another column. E.g. Compare the …

Formula Excel

I would nee help to find the right formula for my spread sheet By: romain