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

Copying formulas to multiple worksheets [Solved]

Hi, I have a workbook that contains 32 worksheets. 31 identical sheets that are basically days of the month. Last one is a summary sheet. I have to add a formula in each of the daily sheets that will sum a range of cells. I want to create the formula in the first page and then copy it to the rest. The result needs to have each page r... Read more

Highlight cell if another cell contains any text [Solved]

Hello, I have been searching and found several discussions similar to this. However none have them were exactly the same and I haven't found my answer yet. Would appreciate it if someone could help. In need C9 to fill out red if any text is entered in B9 I am sorry if this is already answered and I did not find it. Many than... Read more

Copy conditional formatting for an entire row based on one cell [Solved/Closed]

Hello. I'm working on an Excel sheet, where the entire row is colored based on the values of two cells in the current row. If one of the cells in the row is marked with an "x", the whole row gets one color (green), and if another cell is marked with an "x", the whole row gets one color (red). This is OK, and I made that rule work pe... Read more

Copying formulas to multiple worksheets [Solved]

Hi, I have a workbook that contains 32 worksheets. 31 identical sheets that are basically days of the month. Last one is a summary sheet. I have to add a formula in each of the daily sheets that will sum a range of cells. I want to create the formula in the first page and then copy it to the rest. The result needs to have each page r... Read more

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

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

Data showing who pays a doesnt after manually input receipts [Solved]

Hello, Hope im clear on this. Im a bit lost. I have sheet one. This is a spredsheet where we input a secuential number with the name of the student, the date and the amount paid. For example: date # name amount paid jan-1-2018 288478 Ricky $300 jan-2-2018 288479 Monica $3... Read more

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

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

Counting sites visits within a year [Solved]

Hi All, I have a small database that is regularly updated keeping track of site visits and I want to be able to create a table of number of visits within a certain year PER site. Please see a sample of my database below: Site Site Report Date Year Visit Reason ID Name ID 3 MO 39 17/03/... Read more

Counting sites visits within a year [Solved]

Hi All, I have a small database that is regularly updated keeping track of site visits and I want to be able to create a table of number of visits within a certain year PER site. Please see a sample of my database below: Site Site Report Date Year Visit Reason ID Name ID 3 MO 39 17/03/... Read more

Counting sites visits within a year [Solved]

Hi All, I have a small database that is regularly updated keeping track of site visits and I want to be able to create a table of number of visits within a certain year PER site. Please see a sample of my database below: Site Site Report Date Year Visit Reason ID Name ID 3 MO 39 17/03/... Read more

How to apply conditional formatting [Solved]

I would like to apply conditional formatting so that Cell A4 is highlighted (filled) if Cell B4 has Text (date in the format 22-DEC-17) and unhighlight Cell A4 if Cell J4 has text (date in the format 22-JAN-18) If Cell B5 has text, then highlight A5, once text is entered in J5 unhighlight A5 If Cell B6 has text, then highlight A6, onc... Read more

VLOOKUP, IF? Question assigning value to text options [Solved]

Hello, I need to make an spreadsheet that corresponds different text values and gives them a score. I have several tables set up, that I was trying to use VLOOKUP to assign a score to, but I'm not sure what's the best approach. Ex: Column A is one of these text and the corresponding score I want applied (Sally=1, Fred=2) Colu... Read more