The discussions
Excel formulae - returning a zero value
Hello, I'm trying to set up an excel quotation sheet using the following formulae =SUM(B6*C6)+(D6*$E$3/1000) Cell E6 = the quantity Cell B6...
Add entries from a template to a masterlist
Hello, I have a excel template scorecard which I would like the answers from certain cells to record entries from the scorecard to a separate exce...
Master sheet to work sheets
I have an education master template and many other exact duplicate worksheets in a workbook. Each of the other worksheets is differentiated only by th...
Format cell
Hello, Can someone please help. Is there a formula to highlight a cell in a row in column P if it is not equal to the same row in column C. I wo...
Conditional formatting
Hello, I have created an excel database with all of the football games I have been too. In one column I have the home score and the next the away sc...
In one cell more value and another cell less value i need to com
Hello, in one cell more value and another cell less value i need to come automatically higher value in that particular cell if there is formula li...
Rupees into words
Hello, PLEASE CONVERT MY INDIAN RUPEESINTO WORDS RS 10423859/-
Need value as per given criteria
SolvedHello, There is a range given on one column and on the other column there are points. Ex: 200 - 180. 10 points 179 - 160. 9.5 points 159...
If then formula with date
I have a spreadsheet that is tracking when a task is completed in Column C and then generating the next due by date in the next row column A so you kn...
Copy info macro
Hello, I need a macro that can copy specific information based on specific criteria, and to be pasted into new sheets. so for an example i need all ...
How to search particular number string
Hi, I want to search particular number string from all the number data. E.g. - 9822013351 9822012146 9822030078 9822046440 9850038947 ...
Calculating fuel surcharge
Hello, I have the amount which includes freight charge+fuel surcharge that is $14.36. It is said that fuel surcharge is 22%. what formula should w...
Assistance with date formula
Hello, I got a whole lot of data saved as dd/mm/yyyy - need them to be converted to read yyyy/mm/dd - any ideas?
If formula for a range almost works, except with blank cells
SolvedApologies if the title is too vague. I will if necessary rewrite it to comply with forum rules. I have posted this same question here: https://www....
Formula required numeric convert in words
Hello, please confrim how to convert numeric in words in excel. Simple formula required
Positions (1st, 2nd, 3rd etc)
No Name Eng Maths Bio Econs Distinction Credit Pass Fail 1. John Dan 56 67 78 66 ...
Excel macro to create dropdown value of the sheet and values
Hello, I have spreadsheet containing multiple sheets and values in it. I would like to make a macro tool to create a dropdown button of the sheet a...
Auto transferring data from one cell/row to another sheet
Hello, Good Morning. I have a list of transaction in one sheet. With a column showing the sheet name where the data of that row should be trans...
Change cell colour based on values in other columns.
Hello, I would like to change cells in column C base on numbers in Column A and B. So for example, A1=3, B1= 1, C1= Red A2=2, B2= 2, C2= yellow ...
Index , array and need help with print
Hello, I have a database and I created a form using this database . I used "index" syntax and it works but my problem is I need to print this form...
Cannot browse - ftp ok, email ok, ping ok
SolvedHello, I have been following the thread from people with similar problems but mine is not fixed. This all happened yesterday when AVG falsely ident...
Date format
SolvedHello, i have a column in format like 14-02-14 and i want to change it like14-02-2014
If condition formula required
SolvedHello, Thank for the earlier reply. Please help in correcting the formula given below. condition is if a column is AB2>=1 it should reduce no. ...
I need to make a macro with many difficult functions
Hello, I have a basic understanding of macros, but I have never written a macro, or developed something of this complexity. The user of this ma...
If condition formula using dates/no. of days in the moth
ClosedHello, I work for a financial institution and looking for a formula with IF condition.If i collect that month installment, It should reduce the no ...
How to copy data from one sheet to multiple sheets using if
Hi, We have one sheet were the master data is entered. There are different users who input data on this master sheet. How can this data be copied o...
Excel consolidation tab
SolvedHi all, I am wondering if it is possible to exclude one spreadsheet from being pulled into the master tab. I could name it Data. Can you advice? ...
Customer protected form and posting my data into
I have a customer who sends me a Excel bid form that is protected and they want us to enter our price, manufacturer name, catalog number and delivery ...
Excel formula to add day in cell from date
Hello, Is it possible to have a formula that automatically adds the day to a cell if a date is entered into another cell. For example, Column A...
If cell a1 has text then cell b2 has today's date
SolvedHello, I'm trying to find a formula that writes, If Cell A1 has text or any value, then B2 should show today's date and time. Can someone help m...
Excel date format change
Hello, I have use MSoffice-2010,in a excel sheet there is some data with 72 rows.Main issue is when I sent the excel sheet to my friend he got the ...
Comparing two excel sheets
Hello, i have 2 excel sheets, each with 2 columns name and email. the scenario is i want to compare both sheets and display those which has the same...
Excel - repeat rows a specified number of times
Solved/ClosedHello, I'm aware of the post here https://ccm.net/apps-sites/software/1603-how-to-repeat-rows-a-specified-number-of-times-on-excel/ But I wo...
How to repeat rows by x number of times
SolvedHi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in that row ...
Highlight jobs that are due.
Not even sure where to begin on this one and not sure it's possible either but thought it's worth a try. I have a document to record date's when jobs ...
Excel 2003 question. on conditional formatting using vba
Hello, i have been trying to figure out how to make my code stop bugging out on me. any and all help will be greatly appreciated. Option Compare ...
Rounding function
SolvedHello, Good day!! For the Excel rounding function normally is 4 down 5 up is it possible that rounding the digit as below request? 115.21...
Conditional formatting
I have a document in excel where I want to change the colour of a number of cells based on information in one. So I'm guessing a formula will be neede...
Vba to refresh all pivot tables
SolvedHello, One of my worksheets has about 40 pivot tables. I know that there is a pivot table option to "refresh tables when opening file". But my raw ...
Macro to add/remove rows based on highest # in group of cells
SolvedI am looking for a macro that will look at a predefined group of cells (say A1-A5) and create as many rows based off the highest one on another sheet....
Insert row data on sheet2 based on sheet1 cell value(text)
Hello, i have two sheets i.e., sheet1,sheet2 in Sheet1 row fields like A B C D E in that D field value like RC based RC value insert whole RC ...
How to match 2 lists to get the unique entries
I have two spreadsheets, one containing a complete list of titles in a database and the other containing a subset of that list. I want to find the en...
Calculate formula based on values for two dates
Hello, I'd like some help with calculating a formula that uses values corresponding to specific dates. I have a list of daily dates and a value ...
Conditional formatting help
Hello, I have a spreadsheet which we use for tracking all outgoing shipments. I have the expected delivery date in one column, and the actual deli...
Combining rows
Hello, My situation is similar to a question that was asked but not exactly the same. This is how my spreadsheet looks now: A 1 1 0 0 1 1 A 0...
Conditional formatting based on range ofcells in different sheet
Hi, I'm trying to make the conditional formatting based on as follows: cell in sheet 2 is getting red if anywhere in sheets 1,2 and 3 could be f...
Replacing a value using lookup table
Hello, I am looking for help on writing a macro that will perform replacement that will replace the values from A1 to the end of the first row on Shee...
Copy specific cells to separate worksheets upon 2 conditions
SolvedHello everyone, vcoolio has kindly written me a script to copy and paste specific cells from Sheet1 to Sheet2 if ONE condition is met (ie "Yes" is...
Check if cells are blank or zero help please
I have a spreadsheet where columns A and B will either contain numbers or be blank. I need to add a formula into column C (for example cell C2 which ...
Help creating an automated sheet
I need to create an excel sheet that will automatically search information on a "raw data" sheet and give results on a different sheet "sheet 1". I w...