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

Conditional Formatting

I have an excel spreadsheet that takes information from a main sheet and uses formulas to break it down into smaller sheets. I also need it to format the result based on a cell on …

Formula Question

I have tried searching and cannot find what I need. I currently have 5 worksheets within my workbook. They are all the same worksheet just named differently. I need to get …

Procedure on Enter pressed

I have set up a Conversion sheet(mac excel 2007) and would like the cell selection to go to the “RESULTS” column once the user has entered data in the …

cell autopopulation based on item fro drop down

I have a column of multiple rows of drop-down lists with the first choice as a normal in the cell.  Each record will have some of the cells with a diffent choice from the …

http://www.ganardinerosininvertir.com/men/nike-air-force-1-25th-high-leisure-shoes-white-green-nike-men-shoes

nike air max 97 summit white w2014 nike air max orange green grey black flyknitnike lebron 14 navyyellow red cheap for sale 5air jordan 10 retro london nike air force 1 25th high …

DYNAMIC CRITERIA RANGE WITH ADVANCED FILTER

1. I have data in Sheet 1 having 2 columns name Description and Criteria_T and in Criteria_T “*” is used for advanced filtering criteria for text filter i.e. Criteria …

Auto Data Linkage

I have a workbook with three sheets. Each sheet is an assignment tracker for each of my managers. Their assignments are prioritized by either a 1, 2 or 3. I want all of the …

Auto Data Linkage

I have a workbook with three sheets. Each sheet is an assignment tracker for each of my managers. Their assignments are prioritized by either a 1, 2 or 3. I want all of the …

Conditional Summations

Hi,  I have a spread sheet where we enter expenses in a column, in a corresponding column, we have who paid it.  I want to show sum values based on name in the column, …

http://www.seolinkhouse.com/replica/nike-air-max-plus-just-do-it-pack-where-to-buy

adidas rose 6 boost china dnike metcon 1 persian violetnike sb p rod 2 zoom air high euro releasenike free inneva woven tech sp whiteout available now nike air max plus just do it …

Excel Date and IF Function

I use the following formula to calculate days between dates:   =IF(H452=””,”Not Received”,IF(C452=””,TODAY(),C452)-H452)   It returns …

Average of percentages

Excel novice here. This may be very easy, I could be doing the wrong math. I’ve made a spreadsheet to track dollars and other sales levers per hour. There’s a drop down box to …

Formul Question

I wrote the following formula and it works for 11 of the 12 months.  I cannot get it to work for January. It is written the same way except for the last digits. I change them …

Ask about formula

Dear Team, Just tell me regaridng the command of GREATER THAN & LESS THAN. I have core i3 dell laptop. but i don’t know that how i put the greater than symbol in excel. …

Highlight Dates that have expired

I’m working on a spreadsheet where I would like cells to be highlighted if the date in the cell is 30 days  or greater from today’s date. Here’s the story, …

Owner

I need to assign an actual Excel command to a button or shape.  In this case a button with the Excel BACK command.  This is not the “previous sheet”, but the …

User Function causing Excel to run slow

I have a user function that I have been using to seperate numbers out of a text string but I have noticed that when the workbook is open that contains the user function, excel …

Transpose

What I …

Mr.

Hi There I have Problem With Attached Picture Which I wanna cell I4 Displays The Name Of checked Discipline Even Several Discipline Checks Notice For Checked Mark I entered …

Change existing value of cell with formula

I have a spreadsheet with 3 columns. Columd (C) has all negatine numbers in it. I want to add a nhew column (D) where I can enter a value and want it to deduct that value from …

analyst

We have shared drives at work with macros in different excel spreadsheets. These macros work fine for my colleagues, but not for me. I am using the same excel file as them so I am …