## 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 …

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 …

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

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 …

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 …

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 …

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 …

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 …

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. …

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 …

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 …

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 …

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:

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 …

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 …

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 …

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 …

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 …

Eg: Sheet1 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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

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 …

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 …

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 …

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 …

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 …

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 …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.