## Deleting rows in Excel based on individual date range

QUESTION : I have seven Excel files containing information about admissions of several hundred patients to various hospital departments, and […]

## Extracting data from an excel sheet into another excel sheet

QUESTION : I have a sheet with certain data arranged like this: X8 – something – something2 X12 – somethingelse […]

## How can I look up the 2 axis values by inputting a number?

QUESTION : I’m a graphic designer and not very familiar with Excel but I’m fairly sure it’s the simplest solution […]

## Excel Lookup In Table [closed]

QUESTION : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

## Two Spreadsheets, Merge Data?

QUESTION : I was wondering what is the best way to merge two spreadsheets which have the name id’s e.g: […]

## Referncing a cell, based on a cell’s value in Spreadsheet

QUESTION : I understand how referencing a cell works, example being =Sheet1.A1 However, if I’m in Sheet2 and cell B1 […]

## How to refer to the last cell in a row in Excel?

QUESTION : Which function can I use to get the value of the last not empy cell in a row […]

## How to prevent truncation of 0 in Excel sheet?

QUESTION : I am copying tabular data from a website: [http://www.infodriveindia.com/TradeResources/STDCode.aspx?STDCode=&City=&State=andaman][1] But it pastes the numeric value by truncating the […]

## How to prevent all-filtered-out row label values from appearing in a pivot table?

QUESTION : I have a pivot table in MS Excel. For the same of example, suppose the basic data has […]

## how to convert spreadsheet cells to units of time?

QUESTION : This is the goal: +——+———————+———+———————+ | A | B | C | D | +——+———————+———+———————+ 1 | Joe […]