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

Sorting Method

Hi I am using MS Excel 2007 supported by Win 7. I have a spread sheet in which the datas are arranged like Sl. No | Name | Status | User | Type | Nature | email ID | Mob. No | …

Transpose columns to rows and add rows

Hello:  I’m struggling with a gigantic spreadsheet that requires columns be transposed to rows and variable number of rows added to accomodate the columns.  By: …

Row Colour

i want to colour rows based on the row number. i have a macro that will update all rows from 0-190. then 191-379 ect… i want to make the backround of these rows lock to a …

excel

i need these formulas to add together to form a total this is what i wrote =+(I9:I24)*(I29:I34)*(I37:I41) I NEED THE FORMULA TO MAKE THEM ADD A TOTAL IN THOSE CELLS AND GIVE ME …

Excel Formula Help

I’m trying to come up with a formula to handle multiple situations. Current formula: =IF(Indiv!C5<8,Indiv!G5,Indiv!B5).  current formula will return …

manu

need help in advace axcel & vba By:

Return duplicate values

 the attached sheets: i need return values in the “Milestones” sheet. If the dates in the milestones sheet match any dates in column B of …

Macro VBA for cut and paste with Alt + Enter

Hi I have a spreadsheet data where I am trying to perform below: 1. Enter data in A1 : The data in A1 should cut and paste in cell B1 and data in A1 should get deleted . 2. …

Sum of n until m

Hello I want to formulate this [(n=0)∑(n=Ϻ-1) 1/n! (λ/μ)^n ] I’ve been browsing the net for half day and can’t find it. It should be summation of …

Student

Training specialist

Hello this is my first time posting a question so not sure of the format but I’ll do my best. Basically what i am trying to do is create a macro or vba so that depending …

Data Validation Excel Issues – Expert Urgently Needed

Hello,   I am a complete novice newbie to VBA and coding and I would like some help with some coding (hence the length)… If someone could provide me with the correct …

Syncing Saved Spreadsheets

We are currently using one excel spreadsheet and saving it under three different jobs/folders on our computer. Is there a way to make it sync with the other spreadsheets so that …

Replace cell content in Excel by windows Clipboard content

Hello   I would like to paste information (number) from windows clipboard to the excel cell. just by clicking at the cell,  is that possible?    Thanks in …

Excel and Staff Roster

I inherited an unwieldy staff roster. The woman who created it made two manual versions meaning the same updates to staff have to be done manually on two different sheets. …

Formula amount on certain days

Using Windows 64 Excel 2010 I have medication every day I am trying to set up a sheet that shows how many tablets that I need to take when I go away some times up to 40 days for …

Countif problem

Hi, I’m trying to retain an count. My spreadsheet is designed to count the cells labelled “Enquired” and then count. But during my process, cells are changed to …

Need Formula

NEED EXCEL FORMULA FOR BELOW LOGIC:   IF U2=20 AND V2=20, RESULT=PASS IF U2=0 AND V2=20, RESULT=FAIL IF U2=20 AND V2=0. RESULT=FAIL By:

Formula Questions

I am not sure if this is possible, but I’m trying to write a IFERROR INDEX MATCH MATCH formula with a consecutive answer. I have some multiple cells with the same …

Add multiple row after specific Text value

Hello Sir, There is a challenging task in Excel.    Task: I want to add 5 Row after a specific value in a column through VBA Example: I have two names in coulmn A Satish …

Document creation

Hello, I would like to create an something in excel where i enter data and make documents required selections in “sheet1”, click go, and the “documents” …