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

Шпаклевка для гипсокартона: готовая, финишная, видео-инструкция по монтажу своими руками, фото и цена

Плёнка играет роль пароизоляции (бетон может впитывать воду и отдавать в предстоящем), а линолеум …

average function using a location from another cel

I want to averaged 10 numbers in a row by specifying the bottom cell location from another cell where I have generated a cell cell location with =Address(count (d1:d319)-1+6,2,4). …

Format column based on values in other columns

This is my data set, I am trying to create a rule that will highlight unique values STATEMENT 1   STATEMENT 2   E 23.73 D 582.7 A 413.47 A 413.47 B 430.37 B 430.37 C …

Grouping data for graph

20-Jul-17 Elution Pass NA 20-Jul-17 Elution Pass NA 21-Jul-17 Failure Fault   21-Jul-17 Failure Fault   21-Jul-17 Elution Pass NA 21-Jul-17 Failure Fault 24-Jul-17 …

Macro Help – Saving File Name as Text found

Hello.  (using word and excel 2010) I am working off of microsoft word and right now, my code is used to: 1) Separate mail merged pages, remove the section breaks, and set …

formula require

 in one sheet no. is 77031ym05j and in another sheet no. is 77031ym05 (is correct ) so what is the to get 77031ym05 in front of 77031ym05j.. like this   …

+1 Between Time Ranges

I have a matrix I am working on. The matrix ranges from 0000-2330 Monday-Sunday (Columns P-V,4-49). I need a formula to get a +1 count for each person working within a time range …

Excel Progress Bar with Conditional Formatting that Changes Color Based on Value

  Basically….. or not so basically as it turns out, I would like create a progress bar in Excel to show the progression towards hitting an incentive sales credit award …

IF function with nested VLOOKUP

I need a formula using the IF function with a nested VLOOKUP to calculate employee bonuses based on eligibility and pay grade with bonus info being in a table. Please help! Thank …

Unique drop down list option for each column

Hey, I am trying to make columns that have one unique option. First check this image: https://i.imgur.com/uxwX57G.png   Like you can see there is the option to take …

Serial number to the Subtotal Rows alone

Had a Excel Data. Subtotal was done. Want serial Number for the Subtotal rows alone. How to do It ? By:

Find a specific cell by using a row and data in rows and columns

I have a spreadsheet A5 through A11 is ABCDEFG. B5 through H11 has (101,102, 103….) number data in it. B4 throughH4 is 1,2,3,4,5,6,7 I need to wirte a formula that if i …

Workbooks.Open doesn’t work in Excel 2016

The following code works in older versions of Excel, but in Excel 2016 it fails.  No error message… it just doesn’t do anything.  It will work if I specify a …

Using Loop

Private Sub CommandButton1_Click() If (Range(“D35”).Value) <> Range(“D6”).Value   Then    Range(“E35:AQ35”).Cut …

Two Search windows

I swear if things work the same way twice on excel, that would be awesome!    I am working with a huge data file and having to cross reference another file and transfer …

IF Cell = Value Range

I am trying to create a formula to make my cell T2 = $500.00 if cell Q2 is less than $14,999.99. Then Cell T2 to = $1,000.00 if cell Q2 is $15,000.00 or greater.  Can anyone …

Looking up data while omitting recurring results.

I have a project that is requiring me to creat tables of different information.  I have a list 80 store sections.  Each has 30 corrosponding sizes.  I need to have …

Formulas for burnup/burndown chart

I’m trying to create a burndown and burnup chart for my team. However, I’m a bit confused as to what formulas I should be using with the data I currently have. Each …

Need a formula for excell

If i have 2 different sheets with 10 headers (eg “Coustomer name” “invoice number” and “insurance name” etc). I was to copy whatever the …

ADI

    Hello,   Can you help me with setting up a formula in excel that can calculate the average demand interval (ADI) BR/ Nikolaj Period 1 2 3 4 5 6 7 8 9 10 11 12 …

Column Hide and Unhide

Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False For a = 7 To 11 For b = 2 To 3 If Worksheets(“sheet1”).Cells(3, a).Value = …