NOTE:I'm new to this forum & to coding in Excel & English isn't my first language so excuse me if I'm bad at explaining things I will do my best. :(
Hello, there my name is Kovela. I am a financial analyst for a new company. I need to figure out a code that would help me in summary "If Cell...
In my Excel sheet I have values from Column A to Q. Column A is the Serial number Such as 1 2 3.....starting values from A6 as 1.
Column G is filled in without having Blank rows.
Example Column A6 is 1 & Again column A8 is 2.
Hence I want to insert a Row in 8th row & will have a Text TOTAL in...
Hi all
Having a problem with a tab in my excel workbook that doesn't autocalculate some rows.
The equations in those rows are valid but they do not update when the data they are reading from is changed.
Pressing calculate now doesn't update the result of the equation either.
The only way I...
Hey all, I have this UDF to emulate the Subtotal function for calculating the median on visible cells only within a range, but it seems to rarely (if ever) calculate when I open the workbook... I have to enter or tab through each cell containing the function in order to get a value rather than...
Hey guys,
I'm trying to pick random samples from the sheet which contains huge data ( many people data ).
I'm new to <acronym title="vBulletin" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial...
Hi everyone,
So for the sake of an example, say I want to calculate a prices per pound, but there are different colored containers that indicate different prices. Like a red container is $1/pound, a green container is $2/pound and a blue container is $3/pound. So my Data Table would look...
The formulas I have in the sheet were working great, until I worked a day with less than 8 hours. The timecard is not correctly totaling the RT and the OT. I tried changing the formula to take from the total in Column F, which it didnt like because it created a circular logic. Any suggestions...
Hi Dear All,
I have an excel sheet that is feeded by an Access table, so the number of the rows is variable.
I am looking for a code that calculate IDs based on the first ID (123 in this example).
So, the idea is to replace 1000 with (123 + 1) and 2000 with (123 + 1 +1) .. to the last column...
Hi all,
First time poster - bare with me please!
I have a spreadsheet that is very dependent on selected location. I currently have data-validation dropdown lists for continent, country and city - the formula for each list is =indirect('previous dropdown'); ie the 'Continent' dropdown is in...
I am trying to create a series of documents which will auto reference themselves; these documents are of financial nature and the query begins with one level of the series - auto tax references.
In one sheet of this tax calculator I have copied an auto-updating cell reference to other...
I have 2 sheets... both have tables...
One have Item Names in one column and Remaining Qty in the next column...
the Other have Items Names is one column and Qty Sold in the next column...
I want both this tables to get attached with each other in a way that when I put item name in the first...
I am in need with some assistance with Excel. I am looking to do an inventory for mileage on fleet trucks I have on my construction site. I have basic knowledge of building a chart displaying all the vehicles the unit #'s and the mileage. What I was wondering is there a format I can use to...
I'm not sure if this can be done, I've been looking into linking workbooks, connections, etc. Any help would be much appreciated. Here's what I want to happen:
Several users complete an excel form (Form) where only certain cells are unlocked for them to enter data. One of these cells is a...
I am trying to run an automatic goal seek via a button and am not sure what the Macro <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250...
How to keep auto calculate spreadsheets from taking over manual calculate spreadsheets.
When i have an auto calculate spreadsheet open, then open a manual calculate spreadsheet, the auto calculate function takes over.
Other than the obvious - don't open them both at the same time... is there...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.