# Archive by month March

## Formula Problem

I am trying to figure out how to run a premium range from \$1-10,000 until another cell in my calculations equals another cell. I’m can’t find a …

## three cells with multiple conditions and logic

Hi say i have cells cell “A” – with different dollar amounts cell “B” – with either L2, L3, L4 cell “C” – …

## I need to consolidate specific cells of multiple workbooks into one table in Excel

I found this code that does most of the work, but it copies the whole workbook data. All I need is to target specific cell ranges (for example A2, A10, A14:D14 …

## Excel cel values format other cells

Is it possible to format cells based on values in other cells? The values in columns G determine which excel cell indicated and the value in H determines how …

## Multiple Rules, Multiple Rows Conditional Formatting

I have a spreadsheet where the requirement is to change the text color for the entire row based on a condition (the status of the work). I’d like to make …

## Some assistance needed

Aoa, i am Uzma Razzaq from Islamabad Pakistan. i need a formula for excel sheet. As i have record of fee of school students. Condition: If more than one child …

## Excel drop down list

I created an excel drop down list; for example, one category is for months, Jan-Dec, and then there are several weight measurements and blood pressure …

## Excel VBA master sheet copy-paste error 1004

Hello, I am new to VBA formulas in excel. I have a workbook with multiple sheets which needs to be copied(only values) in a master sheet in the same workbook. …

## Incompatible txt-to-csv conversion

I’ve been trying to convert a large (500,000 row) txt file into Excel but several of the columns overflow into the next row due to extremely long cell …

## Automatic Charts in Excel for each row

I have a dataset containing 600 rows and in each row there are 8 different values.I want to make 600 line charts automatically for data set of each row. Is …

## Circular References

My workbook is suddenly telling me constantly that I have circular references.  It’s pointing to cells with formulas that have not been a problem …

## VBA – Spin Button Initial Value not Integer

Hello,   In Excel, using VBA, for a Spin Button, is there a way to program the initial value of the spin button to be x.xxx? Not an integer? By:

## Consultant

Hi,   Excel 2013. I am trying to do a scatter chart for the table below. I can plot the values but I want the dots to vary in shape and colour depending …

## Set a Formula

Hi people^^   If you could help me with this: I have a huge data in excel, where some cells in a column have the same data. So I want any change that …

## 1 tab pulling from 2 tabs

I have 3 tabs, PR, Data, PR & Data. I export data from a time keeping system onsite and drop it on the Data tab. The PR tab has employee payroll rates. The …

## Saving excel content into csv

Hi, I am writing a VBA code to export excel to csv with Chinese characters however it appears as ????? on the exported csv. I assume it is because of the …

Hello I am trying to create a group box and have 4 radio buttons in each group box. I want to assign values to each radio button and i can do so if i put down …

## Which is the best function

I am using Excel 2016. I need to figure how to get the cell to calculate the total by adding specific amounts which are based on an index.  For the …

## Finding and pasting record

Eg:  Sheet1                                        …

## How to get rid of #DIV/0! in an array

Hi! I hope someone can help me with this question. I am trying to calculate the standard deviation of a row of cells, however i would like to not include any …

## IF time is greater than 8:00 then minus Cell from another cell

I need a formulae to work whereby if a time is over 8 hours then the result of cells E10 minus E8 needs to be applied. Tried various way of acheiving this but …

## Sorting Columns left2right by heading to fit a list

Hi This is probably quite easy …. I have columns with headings (headings denoted by H*, cells in table by lettes a, b, …….)   H1 H2 H3 …

## Conditional Stack Ranking

I want to rank a set of information with an objective. If 5 of the 15 people meet the objective, i want them to recieve a rank of “1” i want the …

## to sort column

I want to rearrange the column in excel with numbers in terminal dogit order. for an example i want it in 00001 00011 00011 00111 01111 00021 now its in …

## HIDING ROWS BASED ON TWO CELL VALUES

Hello from Australia.   I am new to VBA (cut my teeth on Fortran, so I am an old timer). I need to have the VBA that tests    The trigger …

## Formula / Equation help

Hello, I am trying to replicate the formula below in excel, but can’t quite get it right. The aim is to use the formula to help drive data that I …

## Formula / Equation help

Hello,   I am trying to replicate the formula below in excel, but can’t quite get it right. The aim is to use the formula to help drive data …

## Excel Timesheets

I am working on a new timesheet.  Everything is calculating and looking great, however, I would like to include a breakdown on the timesheet for employees …

## VLookup Formula Help

Right now, I have a source file that shows several lines of our purchase order (PO).  The ‘powers that be’ would like the total of those lines …

## Make StrPath link to a cel

Hi everyone. I’m currently building a file which will automatically generate a file index of all files in a certain folder. The goal: When you place …

## Basic Count Average Bar Chart

I have a Workbook with 9 SheetsEach Sheet has 4 columns of data:Column A: Login (Time Stamp of User login)Column B: User (Name)Column C: Team (Department …

## Unstructured Data Look Up

Hello,  I’m trying to figure out a way to make my forecasting easier. I get a pdf that I convert into an excel file. The dates available for what …

## Delete Duplicates

Ive got data sorted like this (see below), if I select column by column and then go “Delete duplicates” then it works fine, however if I select …

## given two dates find workdatys in each month

Hello, 2     I have a sheet that contains leaves applied by employees.This sheet has leaves applied for atleast last 4 months. …

## Not enough memory error

Whenever I try to insert a new row in my excel sheet, I get this error. I have enough space on my C disk (30.4GB) and I am using the 64-bit version. I also …

## Looking up text in string

Need to consolidate or look up which client deposited funds to our account. On our BANK DATA we see the account number or a reference from whom the transfer is …

## Best Approach for Dynamic Charts (pivot table or OFFSET function?)

I have data we collect while drilling oil wells. It is based on depth, and then we plot a bunch of data such as geological grain sizes, sorting, tool data …

## Inquirer

Good day. I have attempted many formulas to rid the cells of the ‘false’ statement that appears. Please share what can I insert into this formula …

## Excel – Combining Worksheets to View on One Master Sheet

Good Morning! I have multiple business plans for planting of 10 different crops, on 10 different worksheets. The image image URL attached shows one business …

## problem with excel

hi of the big excel spreadsheet, i only need the page which I can see and not the part where I scroll to the right. I only need to scroll up and down…how …