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

Here is a upstandingoblation as regards you.

Hy there, Rebuke data ! an well-connectedoffers De jure click https://drive.google.com/file/d/1IXdq7ylzqU-zn_nj7385uaYewurQbuA-/previewBy:

Allocating date ranges to specific months

I have a very large table of data that includes, among other columns, start date, end date, number of days and a cost associated to each day covered.  My goal is to allocate …

product list question

  On the right side I have a list of products and revenue and on the left there is the total   is there a way that the left side is populated with a singular value for …

No Page up or Page down key

Hi, I just purchased a laptop and am a somewhat heavy use of excel. The laptop I purchased doesn’t have a page up or page down key and I think I might go crazy if I …

Excel Formulas and Information Lookup

How can I change for this information:    Column A   Column B1 company1  Item12 company1  Item23 company1  Item34 company1  Item45 …

That is an importantoffering for winning.

Ciao! Here is a good bonus offers for you. To qualify click on the link below. http://bit.ly/2J8659PBy:

Date Func Question

        Date          Amount                              …

VBA: How do I perform operations on everything AFTER a specific column title?

I am trying to write VBA code to look for a specific column title (“Master column”), and then to delete unwanted columns after that column, but nothing before that …

Senior Manager – Human Resources

Please provide “If” formula for the below mentioned criteria: If Cell value = 1, then “Poor” If Cell value = 2, then “Needs Improvement” If …

Conditional Formatting formula help

Hi I need to hightliight cells that have increased or decreased by 15% to a cell on the left.   Ie. A4 is 50 and D4 is 75 so I would like this highlighted. The measure would …

Look at an esteemeddocument correct you.

Hy there, Advantageous the facts ! a well-behavedfirst encounter up influential To controlled click on the collaborative menial of …

http://www.lebronjames-shoes.us.com

My wife and i felt now joyous when Michael could complete his basic research via the precious recommendations he was given through your weblog. It is now and again perplexing just …

http://www.marybateswriter.com/retro/nice-kicks-x-adidas-3

2017 nike kyrie 3 bruce lee samurai black red metallic silver for saleadidas chinese new year nmd 2018cavs nike lebron ambassador 10nike air max 95 black black blue nice kicks x …

Complex IF THEN question

Hello,  I have created an excel spreadsheet and need help creating the proper formula to do the following: Column K currently has the following formula …

Excel Formulas

Hi, I have not used excel for sometime and need support. I know there is a way fr this… Link an excel column to another excel workbook however I would like: For example if …

2nd working day of year

I have a year in B2 i.e. 2018. I need to find out the date of the second working day of that year (not first as that would be new years day, a bank holiday) Hope somebody can help …

multiple search

Hi I have excel 2016 I need to search for multiple values Data to be found – Range A1 to A690 Data to be searched in Range B1 to BAE2200   is there any macros I can use …

There is a finickylight on unashamed aside motive of you.

Hey an well-connectedsuggest To equipped click on the reins unworthy of https://drive.google.com/file/d/1wvL-ejftK_U55RVd7uZPpfUMh4gvJH3i/previewBy:

http://www.reebokoutlet.us.org

I must express appreciation to you for rescuing me from this condition. Right after researching throughout the the web and getting concepts which are not powerful, I assumed my …

Combining 2 sheets

I have 2 separate non-linked spreadsheets. Each one of them has one row which called OrderID. The rest of the columns are different in each spreadsheet. OrderID in each …

Split cell

I have one row in my spreadsheet for First and Surname of my customers. How can I split this row into 2 seperate rows – First Name and Surname. Obviously taking into acount …