The discussions
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...
Copy and paste macro
hello, I am new to the vba programming for excel 2010 but what I have been able to ascertain has helped me tremendously at work, however I am having ...
Converting numbers to alpha
I need a simple way to convert a price to an alpha code, for instance Graystoke = 1,2,3,4,5,6,7,8,9,0 so if a price is $5.66 it appears as s.tt I n...
Percentage work
SolvedHi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here I at...
I need a macro please
Hello, I have 70,000 lines of data. I need to make 1400 files of 50 lines each from the original 70,000. So I'm hoping there is a macro that can p...
Recurring weekly date
Hi, I'm wanting to set up a weekly review date for a number of rows on a spreadsheet. Each row has a different start date. I've tried WORKDAY.INTL wit...
Text label and value if value in other worksheet is > 0
SolvedHello, can someone please help me with a formula for this. Text label and value, if value in other worksheet from 2 different cells is > 0, label...
How do i get my old inbox back?
SolvedMy computer had some network difficulty. After shutting down I noticed my Outlook Express inbox was empty. When browsing to my OE folder I see two i...
Question with if function
Hello, I was wondering, if I have for example in C2, C3, C4 the next info: "Tableta Onda V989 Allwinner A80 Octa Core 9.7 Inch Sistem Operare A...
My ipod won't let me use apps
ClosedHello, I got a brand new iPod touch 2nd generation as a gift for Christmas. I synced it with my mac and every song/video/app downloaded with no probl...
Short cut to caps while typing.
Hi, I would kindly like to inquire whether it is possible to highlight a given group of words or sentences that are in small letters and turn them in...
Take reference from previous sheet automatically
Hello, I make a payroll settlement sheet in excel every week. When i make next week sheet i copy previous sheet & start working on it. Sometimes i...
Allow my outgoing mail
Hello, I have tried 465 and 587 and 25 all do not allow my outgoing mail can some help me with my problem
Excel - to generate unique id
SolvedHello, Good day. I would like to generate a unique ID from date and a customer number field. I tried this way but it was not working as desired. Bel...
