The discussions
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...
Putting a password on memory card
Hello, I want to put a password on my memory card that has an audio file, but i want to let it play on a mp3 player without typing the password. ...
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. :))
Corrupt word file - says to use text converter
SolvedHello, I have been reading some posts about you to repair a file and it says to use the text converter. I dont see how to use it though. I want to ...
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 ...
Trying to add a value if a test result is positive or negative
Hello, I have been asked to build a spreadsheet to calculate patients follow up depending on their blood test result. I will only know if the ...
Excel query urgent please.
SolvedHello, I have the below data in sheet 1, where as in column A its the activity and column b its the name of person who has done it. and the names ...
Is there a formula for this issue? thank you in advance
Hello, Please help, the issue goes like this, I want to find a NAME within a RANGE of CELLS and the result would be the LATEST DATE they have i...
Excel list item automatically generates a new list
Hi! Hoping someone can help ;D In Cell A1 there is a list called "clothing" (a drop down box). In the list you can choose "T-shirt" or "Sweats...
Conditional formatting comparing dates
I have two columns, that each have dates in them. I want to take Column A, subtract 100 days, then compare it to Column B. If Column B is less than C...
Auto filter based on cell value
Hello, I have a huge database and ever growing. I need to filter based on a cell value Summary!C2 this value is selected from a drop down list....
Calculation of number of months
Hello, number of months between 1/7/2013 and 26/1/2015 Configuration: Mac OS X Lion (10.7.5) / Chrome 39.0.2171.95
Excel file do not open normally.
I have Office 2010 and Windows 7. I have one Excel file which has very abnormal behavior. First I opened it, drafted it a little, then closed. Next da...
Trying to set up a payroll system for 1 or 2 casual employees
I'm trying to set up a payroll system for 1 or 2 casual employees. Most forums recommend a manual system. Can excel add up a year to date column acros...
Copy select columns from a row given a criteria was met
I have been working for quite a while on a spread sheet for a productivity tracker. I have tried to copy and past several codes and editing them, but ...
2 list matching
i have 2 lists: LIST 1 A1 B1 sku1 4.50 sku2 5.00 sku3 6.50 sku4 2.25 sku5 1.25 need to enter/match these B1 values into a similar, but n...
Want cells to show e.g. £100.00 when there is a value
Hello, I'm using Excel 2007 and I want cells to show e.g. £100.00 when there is a value but when there is no value I want the cell to show nothing...
Time differentials
HELP!!! I have 4 columns and need to figure out the hour differentials Column A has a Date (1/3/15) Column B has a Time (9:00am) then Column...
Vba to copy/paste rows by client name to different spreadsheet
Afternoon, I am new at VBA programming. I have tried sub copyrange and if/then with limited success. I have a master worksheet and individual work...
Data transffering
Good Morning. I am new to the forum thing so any help would be great. I am not sure if this is possible but I am looking to see if I can automatical...
Copy values from a table to another tab
Hello, I have an excel spreadsheet. How can I copy values from a table to another tab by placing an "x" in the right column. I only want th...
Get max value
Col A Col B Col C Row 1 A A 110 Row 2 A A 200 Row 3 C C 199 Row 4 A A 92 Row 5 C C 85 Row 6 D D 172 Row 7 D D 150 Row 8 E E 177 Row 9 E E 199...
Copying unlimited data from on excel to another excel..
Hi All, I want to copy all the data from one excel sheet to another excel on load event (when I open) of destination excel. could you please hel...
Setting due dates
I already have half of the formula needed.. d2=text, leave it blank =if(istext(D2),"","") I need a formula for this: d2=date, then add 14 day...
Looking at one cell if contains number returning text...
Hello, I am trying to figure out a way to streamline a huge excel spreadsheet we have at work. I am trying to return text in a cell if there is...
Copy across conditional formats
Hello All ok I have 20 colomns of data the first 2 rows contain the upper and lower limits(all of which are different) the following 3 rows ...
Compare two sheets based on a common id in both sheets in col a
SolvedGreetings Kioskea team, First of all, my heartiest congratulations and thank you to the great Kioskea team that who have a mine of excellent solut...
Vlookup for mutiple shel
Hi , I have requirement as below There is excel sheet 1 with column A with some text say xxx, yyy , xyz and coresponding numeric values in colum...
Vba to assign a counter to a constant
Can somebody provide me the VBA code for the following samples Before VBA code A B B A C A C A After VBA code 1A 1B 2B 2A 1C 3A 2C 4...
How to convert dd/mm/yyyy to mm/dd/yyyy
Hi All, Kindly help to convert DD/MM/YYYY to MM/DD/YYYY for the following examples. Thanks in advance, 19/08/2014 13/08/2014 13/08/2014 4/08...
