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

E-learning consultant

How can you delete numerous records on a filter without deleting every record in between. Say we have 40k records and we want to put a filter on that displays say 350 records and …

Mapping data

Hello team,    Hope you can help me with my query I’d trying to map the attendance of employees with the transport roster. Following is the date for your …

Drop-down

how to create a drop-down list of names that will update the chronological order based on the name selected for multiple columns? By:

how to get particular values the right hand side final values to the table on the left side

Highlighting all rows that have values within a specific column that match any of the cells of another column

I am struggling to create a conditional format formula that highlights the following; – Highlight any rows of the cells within Column B (worksheet 2) …

Counting Cells based on two sets of specific criteria

Hello,   I’m about to manage 3 different budgets in my place of work with no other method of tracking spend other than a spreadsheet. I would like to have a chart …

formula

Hi   I have a drop down menu in d5 on sheet 1, this menu has the years in 2014,2015 etc, in d15 i want to know which item ive sold the most, and i want it to change so it …

Finding check totals

I have a list of 20 checks. I am looking for 8 that equal $1128.25. Is there a formula applied to the 20 to find which 8 give me my total? Thank you for your time and …

Materials Specialist III

I recorded a macro which does a search for a character in a given cell next to a row of data (200+ rows of data).  Upon a ‘find’ I move right one cell and …

IFERROR INDEX SMALL IF ROW

I am trying to create a formula which will find all of the students in a particular program by subject code.  My formula works if there is just one subject code per program. …

Tab bing issues on secured worksheet

Used to be able to tab through a locked worksheet to locate unlocked cells to quickly enter data into those unlocked cells. Now  my worksheet will go through the first three …

Excel formula

I need a formula for; (Cooling meter/Sum of cooling meters)* Sum of electricity meters I tried =SUM(C2:AX32/$C$2:$AX$125)*$C$126:$AX$187 but I am getting a #VALUE error By: …

500 characters to 500 cells

I have a txt file that is exactly 500 characters wide and can have several thousand ‘rows’ of data that are also exactly 500 characters wide. Frequently I am required …

Nesting

I woiuld like to find all the students in a particular prgram sorted by subject code.  If there is only one subject code per program, my formula works, I am using the array …

VBA failed save

When running some VBA code I get the error message ‘sorry we couldn’t find “File Name”. Is it possible it was moved, renamed or deleted?’ when it …

duplication

    T1 geo 1     T2 geo 1     T3 geo 1     T1 sam 2     T1 Nat 3     T2 Nat 3         i want to …

Organising data

Hi,  I have been tasked with organising data by my boss. I am not 100% sure on how I will achieve it using excel, if someone can point me to what function I should be using. …

Excel Equation question

Hi,   I am looking for equation in excel which subtract 4 from different numbers so as to get a reslut rest number “not in minus and zero” which can not be …

Acknowledgement Form

I supply alcohol to Hotels & Bars (these are my clients). I provide them with an excel workbook known as the OrderForm. It contains many different products (9000) spilt into …

if

i would like to calculate the following:   if any value is entered in 1 cell then the corresponding cells value should be -1  By: Eric

Require help with an excel formula

UE Release Date Observation Month UE Rate Observations Days Daily UE data S&P 500 Date S&P 500 Close 5/6/55 4/1/55 4.7 5/6/55   5/6/55 37.889999 6/7/55 5/1/55 4.3 …