QUESTION : I’ve exported delivery addresses from Pastel into an Excel Spreadsheet. Each address record that Pastel spat out has […]
Tag: microsoft-excel-2010
Can I calculate a date using a date plus 53 days, minus any Sundays
QUESTION : Is there a formula tha I can place in Cell L3 that results in a date by comparing […]
Excel MIN with nested IF statement — Trying to ID a date closest to 30 days after a date
QUESTION : I have 16K plus records with an Auction Date. I need to find the date and amount that […]
conditional chart ranges in excel
QUESTION : I have a table of data in Excel 2010 that looks something like this (but with hundreds of […]
Count skipped cells
QUESTION : I’m aware of IF BLANK and COUNTA but I can’t quite get what I’m after which is to […]
Formula not working
QUESTION : Using following Data my Formula does’t gets correct Answer. The Task is, Sum all Cells has Text starts […]
IE9 not prompting to save downloaded CSV file, opens in Excel
QUESTION : I am accessing a website that generates CSV files when I click a “download” link. Instead of prompting […]
How to Link Cells in Column to Cell in Rows
QUESTION : I have an Excel database. I want to link Column cells to Row Cells. One by one doing […]
referencing cell based on specific data in excel
QUESTION : I want to get the cell address (column number and Row number) based on the data it has. […]
How do I determine if a value is between range of values specified in two columns and return another value from the row where condition is true?
QUESTION : I have a value that I enter in cell B5. I need a value returned from column C […]