Archive by month November

Need Decimal for ICD9 codes

Hi I am needing a Macro to add a decimal after the third digit for ICD9 codes. I have several diagnosis code that need a digit. The codes are located in column …

Updating Pricing Question

Hi, I am tryign to combine a VLOOKUP function and an IF statement. Basically I want to quality check pricing for a product using an ID number, so do a …

Data Consolidation

I have a spreadsheet with over 3000 names, dates of notification of training, and dates of completed training.  Roughly 2000 of those names are the same …

please help I have data on one worksheet (postcodes m1, m2, m3 to m90) with corresponding information (no. properties sold) on another spreadsheet I want to …

SUMPRODUCT text/vs populated cells

Hi There, I am trying to create a formula to count the amount of forms returned by a department. The database is set up in a way as such:   …

salary – different break points

I want to set up a spreadsheet where the first €25000 goes to one person. After that the next €35000 is divided with the second person getting 70% …

How do I remove variable length text from multiple cells

I am a bit of an novice, and would like to know, if and how, I can copy a string of text from the end of string in a multiple cells?   cell range A2:A50 …

Minimum Value

Looking for function to record the minimum value in a range of cells excluding zero’s By:

SUM two cells, but one cell is only worth 8 max

I need to add the values of two cells, however, one of the cells can only count up to 8 points. For example, cell B3 = 10 and cell B4 = 24. All of cell …

Sales percentage

Hi I have the following problem for a salesman. If he sale the product with 20% mark-up he will earn 5% commission and so on based on the below plan…How …

Select Case – Active Cell Delete

Hi, I have written some code to loop down a column in a spreadsheet and test for case is >0.001, this works when the cell value is greater than 0.5, however …

How to link comments to a particular point in an excel chart

Hi,I would like to populate comments on to an Excel line chart that help annotate the story it tells.   The chart has time along the X-axis and the …

Count/sum Large with not to exceed

I have 321 clients, each with sales and cost of sales values. Trying to apply the 80/20 rule to determine the sum of cost of sales for the clients that …

finance manager

Hi, I am in the process of building a utilisation tool but need to incoporate the available hours to be utilised within my data table, for example; I have 4 …

method ‘range of object’ global failed

have an access data base where i generate 2 excel reports as the final step. when i run report 1, the excel part works fine. when i try to run report 2, i get …

turn a negative into a positive

Hello, I have a formula that subtracts the values of two columns. If the value of the first column is negative, I need the formula to add the two coumns …

EXCEL IF function using date

Hi, I’m trying to run an if function in excel which will add up the numbers in one column depending on the values in 2 other columns.    The 3 …

excel freeze pane

Hello everyone, i would like to know if there is a way to do multiple freeze pane. what i am looking to do is as i scroll down i want certain rows to be frozen …

checkmark

I have built a spreadsheet to track patient test by name. I have used a checkmark in the cell to represent that the test was done. What I’m needing is …

Controller

I have an Excel file with multiple tabs for each month.  In that file is a master tab that I would like to continually update with changing information. …

Excel formula required

I would like a formula to find which cell (A1 or A2) has a positive number then deduct 2 from it and the balance is the resultant. Known factors. a1   = …

Excel Function

A B C D Status 1 1 0 4 A, B, D 0 1 2 3 B, C, D 1 0 2 3 A, C, D 1 2 3 1 A, B, C, D Hi, I am looking for a solution or a excel function to reach a solution in …