# Archive by month January

## Checkbox Macro

“Hi, I have a workbook with 30 worksheets(tabs) reading off a master for some of there data. I would like to select worksheets with checkboxes and press …

## Help with Countif and VLOOKUP

Hello, I have a spreadsheet with 3 columns Column A has barcode Numbers Column B has the product name Column C has the product QTY amount I like to scan a …

## how to insert rows

Spreadsheet contains  Col A  Col B  Col C (Derived from ColB-ColA)  1         9        8  11 …

## Macro- Email Address Clean up

Everyday I pull a spreadsheet of demographic data that includes name, DOB, and email address. I upload this spreadsheet to send out mail to all of the email …

## Excel 2013-Filter/Drilldown question

Hi, I have an Excel question. I am trying to create a list of data (that will grow) and I need to be able to filter down. 1st-Question- I have 6 rows …

## IT support

HI  Came across this web and I have an excel problem =COUNTIFS(B4:B6,”>10″,B4:B6,”<=13″)  works   …

## Fleet report manager

I use a software that is online to track my companies fleet. I am creating reports in excel for things like fuel consumption. I download the spreadsheet …

## cell difference + or –

Hi – I have created an excel ss and I have numerical values in column g at 1,14,23,29,34 etc etc throughout the whole ss of 1889 rows. I would like to …

## IF Function

my formula is =IF(F12>=1.6,”Development Needs”,IF(F12>2.5,”At level”,IF(F12<=1.5,”Action”))) I need to be able to …

## How to use LEFT, RIGHT Functions and add them together

Hi there, I am using =IF(X14=””,””,(LEFT(X14,1)&”/”&RIGHT(X14,1))) for below table  10.6+ 1/+ 8.8 8/8 7.2 …

## Change cell colour based on value

How do I change the background colour of a cell based on it value.  For values between 1-5 I want the cell to be yellow and from 6 – 10 it …