The discussions
Can i accomplish this with conditional formatting or another way
Hello, I have two worksheets. I would like to enter values in a column of sheet 1. When any of those values match a value in a table on sheet 2, ...
Excel
Hello, I Want to change date format dd/mm/yyyy to dd.mm.yyyy in MS Excel 2003 Please solve my problem urgently
Removing false in excel
Solved=IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000)))) What,s wrong in this formula Please Help!
Increment a cell value - conditions applied
SolvedHello, I needed a formula to add a value to a cell when the cell next to it contains a value where that value is obtained by incrementing the value ...
Michelle
Hello, I am Having enormous difficulty with my MAC keyboard operating in Excel. I feel i must have put the scroll lock on but cannot find any ...
Want to copy sheet1 data to sheet2
Hello, hi there i am just new to excel and iam trying to understand by praticing by own i want to copy sheet1 data to sheet2 when im typing in she...
Apply a negative until 0 is reached in excel
I am trying to create either a formula or a macro (which I do not know how to create) so that the following rule works: (1) If last row of data (ie c...
How to merge the data from 2 different sheets into 1?
I currently have 2 spreadsheets which show payments from 2 different companies. I'd like to be able to merge them into one spreadsheet which updates i...
Rating from parameter lookup
SolvedHi.. I have some data that reference parameter to fill Rating in my excel sheet. The problem is those parameter are in Text Type. Here is the e...
Nesting if() functions?
SolvedHey guys, I'm relatively new to Excel, so bear with me here. I'm making this spreadsheet to check if the payments of certain products are either la...
Excel macro create new sheet copy & paste cells
Dear Sir I need help in a macro to create a new sheets with colum A name and copy row cells to the new sheet. Name Age Gender XX 25 M ...
Automiatic email
Hi all, I have used excel for years but never at an expert level. I am currently in a position where I need to view multiple tabs of data daily to...
Help help help excel formula
Hello, I really need help trying to figure out this formula, as I have tried so many different formulas and can't seem to find one that works. I nee...
Due date reminder with an email to the filtered list
Hello, Here I have a filtered list from Master Sheet to DueReminder Sheet In which column I represents Email address Now my motive is to se...
Change date format using excel macro
Hello, In SAP BI I have created a BEx Query. We can see BEx reports in MS Excel. Date format in the report is DD/MM/YYYY and I want it to be displa...
Comparing excel sheets with only a few overlapping records
Hello, I have two worksheets (1 & 2) that have different info, with not many duplicate records. I need to identify the duplicate records. I can ...
Mtch formula required
Hello, In one column - A i have name for eg -Anuj Muchhala and another column B - Anuj & column C - Muchala - I want to know how to match maximum ...
How to make a cell flash using excel 2011 for mac
Hello, I have Excel 2011 for Mac. Is it possible to make a cell flash using the Mac version of Excel 2011? If so, how is it done? I would apprec...
Replace cell content in excel 2007
Hello, I've two columns like below and i'd like to replace the one in 1st column with the one in column B in another table. Name_A Name_B Joe ...
Macros or vba for data validation
Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) Anybo...
1 time data entry
Solved/ClosedHello, is there any way that make a condition for a cell which don't let to any body change the cell after they enter the date. i mean when i enter...
Add an x to cell if other conditions met
Hello, I've got a list of products for an e-commerce site. What I'm trying to do in Excel is flag any items that have a quantity of zero AND are i...
Convert numbers to words in excel
please clarify my problem "convert numbers to words in excel"
Mm/dd/yy and dd/mm/yy and mm-dd-yy and dd-mm-yy in one column
Hello, I have the problem of having all the 4 date formats in the very same column: mm/dd/yyyy dd/mm/yyyy mm-dd-yyyy dd-mm-yyyy I would nee...
Replacing duplicates
Hello Trowa Sorry to bother you again but a problem has arisen. Everything was working OK until I tested "Pair names 4" Column Q. When I ran the code...
Due date reminder in excel to new sheet?
SolvedHello, I Have a problem in this code =INDEX(Master!$B$3:Master!$B$1067,MATCH(TODAY()+30,Master!$H$3:Master!$H$1067,0)) HERE I HAVE COLUM...
Copying a row to another sheet with a trigger
Hi All, I was preparing an excel workbook, based on the sales pipeline. To simpify, The first sheet has company name and contact column. Titled "...
Format based on another cell with a letter.
Hello, I would like to know if there is a way to apply a format formula to a cell but to use a letter as criteria instead of a number? Example:...
Regarding pivot
SolvedHi I am doing Pivot for multplie data . In the Value field ( bottom right ) , I need SUM as default instead of count . I have to drag multiple ...
Paste at end of data
Hello, I'm trying to write something that will copy and paste cells AC10:AQ15 from a sheet called "Format" to the end of column AC on the sheet ca...
Counting words, names as number values
Hi, Ive been searching for a way to count a list of names as a number. I currently have to place a 1 in a column next to the list of names. And have ...
Find the first available (empty) cell on a worksheet.
SolvedAs a newbee to VBA, my boss has given me an impossible task ... Basically I need to be able to enter one cell worth of data from one sheet of a wor...
Trying to see if i can even create a macro! please help!
I want to know if its even possible to create a Macro whenever I copy/paste information that is provided to me weekly, which in this case is in th...
Lookup problem.
SolvedI have a column of 20 dates in col. B spaced by 2 or 3 weeks, and a number beside each one in col. C. In cell C24 I need a formula that returns the v...
Copy paste data in same column for multiple time
Solved/ClosedHello, i need following manipulation.... Data Before Column "A" 123456 123456 123456 123456 123456 ( After )Column "A" (After copy p...
How to change text color dep.on the value of another cell.
Hello, I have 2 questions: 1. I'd like to change one's name color to red if that is in debt. 2. want to count a. all names (number of all people); b...
Multiple if functions with dates
Hello, I am rather new to creating Excel formula I want to create the following rule working with dates: IF date in A1date in A2, then date ...
Compare a cell whit itself (conditional formating)
Hello, i want to know is that possible to compare a value of a cell with itself. for example i enter "10" in cell B2 tomorrow i want to change it...
Due date reminder ahead of one month and mail that to customers?
dear sir/madam Here there are 6 columns with 'n' number of rows. Column 'E' represents DUE DATE of particular 'Sol ID' and this date is common...
Replacing duplicates
Solved/ClosedMy Excel spreadsheet is set out as follows: A B C D E F 1 2 14 0 14 14 2 1 13 0 13 13 3 4 4 1 4 4 4 3 3 1 3 17 ...
Compare and copy in column
I want to copy data in column 'B' when column 'A' is not blank. 'A' column has some blank rows. please give me solution!
Excel - macro to highlight rows with duplicate values in a cell
Solved/ClosedGeetings, Kindly help us in creating a macro that highlight rows based on duplicate values in a cell [this cell may contain Alphabets, Numbers or ...
Key board shortcuts to navigate along an excel sheet
Hi all, I would like to know if there is a keyboard shortcut to navigate from, for example sheet 1 to sheet 2 on the same excel file without using th...
If function with date in excel
SolvedHi, hope someone can assit. I need to create a sheet where I must take the current date and add a fulle week or two weeks to the date by selecting an ...
How can i create worksheet as date from 1 jan 15 to 31 dec 15
Hello, I would like to create 365 worksheets with sheet name as date. Could anyone help me. Many thanks in advance. :))
Macro for copying data from different sheets
Solved/ClosedHello, I am trying to copy data from different sheets to master sheet under the following criteria 1. Master sheet should be generated when ev...
If / and function and date range
I am trying to create a spreadsheet that tracks when jobs commence and complete. I have been working with the IF and AND functions but can't quite see...
Excel 2007 : conditional formatting issue concerning colors
Dears, I've successfully put a conditional format in my document, but I would like to have the whole row in color in stead of only 1 cell. Does ...
Useing (='sheet'!cell) if the sheet name is depending on cell
Hello, how to use (='sheetname'!targetcell) if the sheetname is in cell A2(sheet1) and the target is C3 ='sheet1'!C3 is working, but the sheet ...
Trying to sum a column that contains various text
SolvedI'm a novice when it comes to excel and I'm hoping someone can help me with a formula. I'm trying to give a value to various text in columns and then ...
