# Archive by month March

## Excel

is there a way in excel where in I put a number on new worksheet and automatically image attached to specific number in a existing worksheet gets displayed By: …

## DAta Validation Filter list

I have a database query that extracts this data in sheet <AccountNumber> Curency Account Number EUR       123456 …

## How to use INDIRECT Function in Excel

The INDIRECT function in Excel displays the contents of a specified dynamic reference. The INDIRECT Function is great because you can reference each attribute …

## Personal Mileage

Hello, Please help i am currently trying to figure out the best formula to use when calculating cumulative mileage claims, for example if Mr A has driven 9500 …

## Populate combobox from column based on another column

I have a number of user forms. Let’s say 5. Stage 1,2,3,4 and 5. At stage 1 a serial number is entered into a text box. At stage 2 the serial number …

## IF, OR Formula Help!

Hi I need to create the following formula in Excel – please can you help! If A2 is less than 5 OR A3 is equal to or greater than 3, then A4 should read …

## Creating a 5 week average formula that does not automatically move down when a row is added

I’m trying to create a 5 week average formula. However, every formula that I create seems to change by one row when I add in new data for the week. I …

## IF Formula if Time is Greater than 10am

Hi, Here is my issue. In column “F3” I have a import time in the format 09:00. In column “T3” I’m trying to create a formula …

## merge data

hi  can we merge or bring data from different excel sheet to one excel sheet. for example i have a excel file with 3 sheets namely sheet-A,sheet-B, …

## IF or INDEX ? both ?

I am trying to determine the best approach for deciding on a freight carrier for my orders, based on multiple critera…    My  Orders …

## EXCEL

Hi, What is teh best way to solve the following scenario? Spreadsheet A Column A is the ID code Column B is the AVERAGE price Spreadsheet B Column A is the ID …

## Remove Spaces from Start of Cell

Hello As the numbers below is imported I can not use auto sum. Beside from the m at the end (easy fix) I have one to four spaces in front of the number. How …

## if function comparing cells

hello, i want to write a logical function assuming in C2, for lets say if another cell in column A (i have about five thousands rows) is same as A2 and the …

## Find Salary in Range

Hi – I am attempting to match a employee’s salary with the nearest value (rounded up) in a range. For example: Employee A — \$45,000 — …

## Index and Match returning #NA

I am using the following formula in Excel 2010 =INDEX(‘S:1 FOLDER FOR CORE DOCUMENTS CLsCL0022 – Showroom Catalogue[CL0022- Showroom …