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

none

i have a sheet with 20 rows and 70 columns. Am trying to compare column 70 and 69, 69 and 68 and so on and highlight uniques….any easy way? By: anita

VBA Copy rows with criteria met

I am trying to create a VBA code that will find all rows on Sheet “All” that have “Completed” in 1 column (column B but A is hidden if that makes a …

How to fill or change font color if date completed is greater than 48 hours from date entered.

I’ve tried searching this and keep coming up with conditional formatting results but can’t seem to find the correct formula.   I have two columns with multiple …

http://www.thichlashare.com/fnjx/pas-cher-nike-free-flyknit-chukka-rouge-noir-en-ligne-for-vente

sale nike free 4.0 v2 herren schwarz blauwhere to buy nike prime hype df 2016 royal blue black whitenike magista onda fg baskets de femmes volt blanc retard sur le bleu noirnike …

Manager

excel 16 mac array formula if values in column A = values in column B move corresponding value from column C to column D By:

How to Sum?

How to Sum Values in a cells if :   cell shows 5 (7/14) which is number 5 on the date (7/14) I need to get my row to sum and ignore the 7/14 inside the parenthsis.  By: …

http://www.corralonghezzi.com/fceu/nikelab-zoom-hyperrev-x-fragment-black

homme nike dunk faible scotland marron avrilnike performance handschuhe damenblack white anthracite nike lunarepic low flyknit 2 running shoesnike air max 90 ultra 2 0 ltr cargo …

Proble of multiple excel workbook

I have created 3 MS Excel (.xlb) workbooks, 2 of thw workbook have multiple sheets (3 sheets). These multiple sheets in the 2 workbook feeds data into the 3rd Workbook (with 1 …

Formula for Match row & Column

Hi, I would like to match the numbericals values between ROW & Column and the matched insectign values should be mentioned in the empty column. Can you help in picking the …

solver tool

Dears , Kindly your support to do below : When we want to weekly upgrade / downgrade capacities we must change all sources and this takes much time to finish  . I suggest …

Tables within a table

Hello, I have a table of employees and some of their information. Long story short, I have had to make each employee into their own little table to filter through other …

Formula Help – Time

Hoping to get some help, I have a sheet with one of the columns representing the start time for a task as a custom category of d/mm/yyyy h:mm  I am looking for a way to …

Auto Update Pivot Table issues

Hello,   I am having issue having pivot tables automatically updating. I am trying to use the code ThisWorkbook.RefreshAll Tab 1 is going to be my dashboard Tab 2 is …

Shawn Kelley Jersey UK

“Enhanced Customer Support by System Generated Personalized SuggestionsEvery time your customers book a ticket using your application, he will leave a trail behind. Connor …

http://www.rccgarkofgod.com/sxfw/femme-nike-air-max-90-candy-drip-melt-vert-noir

comprar nike air max thea mujer ofertas y descuentos ptree394high quality shoes nike lebron 13 black team orange whitezapatillas nike huarache outlet baratas espa帽a 2018nike …

meena

I wrote a code to insert a pic in word and resize width and height with the values in excell cells. but they are not tallying.   For Each SHP In ActiveDocument.Shapes   …

Find-sort duplicates to unique values

Sample Text Which I Receive Sample Text Which I Receive                 FLAGS STAMP# DATE     EXP: 1 FLAGS STAMP# DATE   …

formula help

I have text in A1 that I am trying to locate with text in column B. the cells in B contain more text beyond what I am looking for in A. I need it to find A within B and return …

formula

In one column, I have a beginning balance of $100(A1). 3 debits: $10, $20, $30 in A2, A3, A4. I want to add A2, A3, and A4 and then subtract that total from my beginning balance …

Analyst

Hi, I am not sure if this is the appropriate place to ask this question. I’ll go ahead please indulge me. In my Pivot, i have several questions that have two options …

Break a Block of Time Out Into Separate Months

I have columns of dates and times that fleet vehicles have been taken out of service (OOS), and a second set of columns in which the vehicles have returned back into service …