# Mazzaropi 134

Contributor
Registration date
August 16, 2010
Last seen
April 5, 2018
Contributions
626
Gender
Male
Location
Belo Horizonte, BRAZIL
Signature
Belo Horizonte, MG - Brasil. Marcílio Lobão

## How to count how many times a number appears in a spreadsheet? [Solved]

Hey~ I need to count the number of times a number appears in a spreadsheet. For example, how many times the number 1 appears in an entire spreadsheet. I have the formula =COUNTIF(B6:M59,"1") but that only tells me how many times only the single digit 1 appears. I need to count how many ones total even if it appears in 11, 16, 21, 51. S... Read more

## Excel - Lookup Query...

Hi, I'm trying to find something similar to this but I'm having trouble. Im no way an expert but I know my way around and basic functions.... I have a list of addresses in Sheet 1, the whole address is in one cell. So for example A2, A3, A4 all contain a different address. Then in B2, B3, B4 etc I want to display a area code, "... Read more

## Excel partial match [Solved]

Hello, Hello, I have a small query related to Excel Search function. Suppose I need to search the below data in target cell which has some errors , but a partial match of data is being accepted. Which function can we use as I have tried Match & Vlookup it only searches for exact data. Is there any function for partial match of ... Read more

## How to easily cummulate data [Solved]

Hi there, I was wondering if you guys know how to do this: got 13 weeks, each week has a figure underneath it. Let's say week 1 has 1 under it, week 2 2, week 3 3 etc. In a drop down I would like to select eg. week 5 and I would want excel to calculate all 5 weeks combined in one cell, i.e. 1+2+3+4+5. Is this possible with a formula p... Read more

## Automatic Payroll Computation

Hi everyone. Im just new to my job and one of the task assigned to me is to compute payroll for our employees. im not that knowledgable with excel, may ask some help or atleast some guide of the format used for automatic computation? Thanks in advance.

## How do you change cell colour based on date

Hello, How do you change cell colour automatically based on date. I am trying to set my training spreadsheet so I can clearly see when staff members are due or have upcoming training. I am looking to do the following: Overdue Red Due to renew in 30 days Orange In date ... Read more

## School report card with data of all classes

dear sir/madam i am looking for excel work for school report card, one sheet where i want to put data as where data will be entry(sheet-1) class-I subject roll no name neglish-1 english-2 beng math physics lifescince geo hist drawing total average GRADE 01 ANISH ... Read more

## How to add 200 working days to a given date. [Solved]

Hello, Please I want to know how I can add 200 working days to a specific date to get a new date

## Cell background colour

Hello, Is it possible for a cell to change colour as a warning that the date in the cell is nearing going out of date. System Configuration: Windows / Chrome 63.0.3239.132

## Row conditional formating in Excel [Solved]

Hi All, I'm trying to play around with the conditional formatting in excel to highlight a row in excel if a cell in that row contains certain text. There is solution around it? Thanks

## Subtracting amounts from a fixed amount

Hello, I need a equation for subtracting amounts that i entered from a fixed amount. Here is my screen shots. I enter 10000 in row 1 column A Then i enter 500 in row 2 column B That time my subtracted amount will be show in row 2 column C(Ans:9500).Then again i enter 200 in row 3 column B the answer 9800 will show in row 3 column ... Read more

## Autopopulating new sheet based on an ans in 1 cell

Hi, Hoping you can help. I need a solution whereby if I select a certain value from a drop down list it will autopopulate that row of data in a separate sheet. In essence I want to create a list of companies who are talking to us about a specific product, where this is identified in the first sheet. Thanks in advance for any help ... Read more

## Highlight Help [Solved]

Hello, I am needing help with being able to highlight a cell based on another cell's value. Example: I am dealing with cells J2 and J3. I am needing to highlight "green" whichever of those two cells contains the greater numerical value. TIA!