The discussions
How to convert date into words(english) in excel 2003 or 2007
Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April Two Tho...
Create multiple workbooks in a particular format from a table
Hi, I want to create a macro wherein I can create multiple workbooks in a particular format from the data from a master table in a excel workbook. ...
Error trying to populate new worksheet using macro
SolvedHey everyone, I've been working on a macro to create a new worksheet based on the information entered into a column of a "data" worksheet which pop...
Add string only if a text is present in a cell
SolvedHello, i have this string =CONCATENATE(MID(B5;1;1);".") i use to have the initial of a name like this: from "Name" to "N." but some fields have no...
Copy cell from another sheet where cell is value...?
SolvedHi, Is it possible to copy a cell from sheet 1 to sheet 2 where (for instance) sheet 2 A1 is same value as a cell in sheet 1? What I have is: sh...
Macro for filling data from specific cell to another
SolvedHi all, i need help with creating macro to fill data from specific cells in column to another specific blank cells in other column. screen shot i...
Complicated if/then copy operation?
if (column range; eg, A8:A42) has any value, then Copy a cell (formula; in C2) two columns to the right of every cell in that column (A) that has a va...
Rows and columns
Hello, I have the ffg problem, i have a table as below: PN H1 H2 H3 H4 A AB AC AD AE B AB AD C AC AE D AB AC AE and I want it t...
Nesting if formula problem
Hello, I'm trying to set up a worksheet for student participation grades. Once I arrive at a participation average, I'd like to have a formula to...
Error: embedded excel spreadsheet
Solved/ClosedOccasionally I have an error with my embedded spreadsheets- it is "Microsoft Office Word can't start the application required to open this object. An...
Excel -formula that excludes names if other colums have info
Hello, I have a list of 50 names in Column F, I used the Coutif formula to tally the total names in colum Q:5. ex. =COUNTIFS(F3:F1436,"=bill*"...
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 ...
