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

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.

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

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!