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

lookup and reference

Find all the values in array1 that correspond to a number in Array2, i.e., for # “8”, the return would be “Al”, “Bt”. For # “28”, …

Excel Formula

Hi,   I would like to know what formula we can use to get the forcast of the PRE QA numbers from the disqualification trend we are having? for example: if i have to …

Iterations only done for some cells, even though the other cells have identical formulas

I’m doing a spread sheet which involves circular references. The iterations function has been enabled to allow the circular references to work. Basically the circular …

Complex Formula

I am looking for a formula to go into G2 that finds the combined sum in column D that is adjacent to the product in column C, but for the choice of product to be dictated by the …

Как избавиться от боли в суставах?

Пантогор – гель для суставов быстро избавит от боли в суставах без вреда для здоровья. Полная …

Conditional Formatting

Hello Im using dates on my spreadsheet and I want to show a date to be highlighted if its greater than another cell by 18 months, If its less than another cell by 18 months, if it …

500 min formula

I hope I can explain this correctly.  I am trying to convert numbers that are less than 500 in a cell column to 500. But if a number in said cell column is 500 or above, I …

Auto update slicer

I have a column of data organized by month. On a separate sheet, I have a pivot table and a slicer connected to this data. When I enter new data, I want the slicer to update …

Zoo porn reviews site?

Good morning, Weird web pages I’ve found on the internet – they have a lot of man on horse fuck webm zoo porn on this zoo review sites. It called …

Data analisis help

Hi , I have the folowing information.  Customers names, visit history, and how much they spent. I need to create a visual chart or graph that can be updated daily with new …

Compare two values in an array and if they match in a row, return a value from the third column in the same row.

I am hoping someone can help me solve this specific problem. I understand it may have something to do with VLOOKUP, or MATCH and INDEX and array formulas but I cannot quite get …

Excel formula

Im using windows 10 and excel2010 I am trying to come up with a formula that finds the highest ascending number in a sequence, the numbers are across columns e.g. …

Excel Conditional Formatting

Hi, I’m currently trying to format cells in different columns so that when I select a duration option in one column, the rows in a different column are shaded. For example, …

repeating data based on other data

i’m still relatively new to excel. i’ve been working 15+ hours on this sheet and figured there must be a faster way to do this. essentially, i’m recording words …

Excel vba IF THEN ELSE statement

Hi.  I have two Subs:    one inserts a shape (“Checkmark”) on top of another shape, a square, and    one erases a shape …

Auto populating data

If I have employee name (column a), employee number (column b)and a classification of employee (column 3).   Master list on employees in sheet 2 I want to be able to …

Consolidating text data by reference number

Hi,   I have a spreadsheet with 35000 lines. Each line contains a customer name and the archive box code where their information is stored. I need to consolidate this …

Sort data and form graphs

Hi there! Relatively new to excel, so please bear with me   So I have a spreadsheet of data that sort of goes like this (NAME, AGE, SCORE, TIME) JOHN, 12, 2324342, 13 HENRY, …

How to extract a number from a text string in google sheet

HI   In my google sheet A1 cell, this is written.    <!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–>Get 48.81 rupees per …

Sum certain cells

I have a column of 6 cells and I only want the top 4 summed up in another cell, how can this be done? By:

If Statements

SEVRENE® 3000-70A-8870 XDV DARK SLATE Is there an If statement that would pick out SEVERENE from the above, change SEVERENE to SEV in another column, and if SEVERENE was not …