The discussions
Set cell value
SolvedHello, how to create formula for: if AI=1, B1=2 than show C1= 25....... if A1=1 B1=3 than show C1=28........ if A1=5 B1=5 than show C!=32.... ...
Vba copy sheet to new excel file + automated manual data entry
SolvedConfiguration: Windows 7 / Firefox 35.0 Dears, I hope this is not a to extensive VBA script request and this is the place to ask. I need to cre...
Excel formula
Solvedhello, hope you can help! working on an excel spreadsheet and require a formula: If cell a > 0 then cell b should equal the value in cell c thanks ...
Code visual basic
SolvedHello, I've been unable to copy data from one sheet to another, based on selecting multiple criteria. I've been able to use the string below t...
Excel formula display in cell
SolvedHello, Apologize if the question is too stupid. In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to display the formula in cell A6 for this...
Some cell date could not change
SolvedHello, I was having the same problem and this solution worked But Some cell Date Could not change Configuration: Windows XP / Firefox 36.0
Comparing data in 3 columns on a microsoft excel spreadsheet
SolvedWould be really grateful for some help. I have 3 columns of different lengths with email addresses in them and I want to see all instances where th...
Excel 2013 formula - maybe if formula?
SolvedI have a list of names in Excel and I need to put their supervisor name in the cell to the right of each name. I would like to find a formula that wi...
Wordnum help needed
SolvedHello, I hope somebody can help. I use WordNum to spell the result of a formula and it gives me 4 digits (spelled) after the point. I need just ...
Cell format
SolvedHi Guys, I'm new here, I have a very limited knowledge about excel. My superior has asked me to do some sort of Advanced Cell Formatting in our per...
Text-to-text equals number
SolvedHi.. I'm looking for a solution for a dilemma I'm in.. On sheet 1 I have a dropdown box in cell A1 and B1 is an emtpy cell. On sheet 2 I have the...
Formula, blank cell
SolvedSorry in advance if this has been asked but I can't see anything. Excel 2010 I have a cell that will contain a date then the next adjacent cell the...
Convert date into words(english) in excel 2003, 2007 or 2010
SolvedHello i want to know how to convert date into words(english) in excel 2003, 2007 or 2010 for eg. 22.04.2010 - convert it into Twenty Second April T...
Conditional formating is applied based on date in two cells
SolvedHi everyone I'm using Excel 2010 and applying conditional formating on dates in Column E. I don't want the formatting to be applied if there is the f...
Excel - help please! drop down and data filling
SolvedGood morning/afternoon. I was hoping you would be able to assist me with a query please. Currently my team is using 2 spreadsheets, one that li...
Trying to have the current date go into one cell (a1)
SolvedHello, I'm trying to have the current date go into one cell (A1) when an order number is entered in another cell (A2) but don't want the date to aut...
A strange range question ...
SolvedHi guys Im back with a new twist on one of my old problems. I had help earlier and one of you kind people hellped me out with a solution (thanks ag...
Adding a loop to macro to insert pictures
SolvedHello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...
Change calculated to a hard date
SolvedI used a +1 formula to create dates in column A. Now I want to make these "hard" dates so they don't keep changing every time I add a row. Thank you...
Transferring numbers to new worksheet automatically
SolvedHello, I'm making a spreadsheet showing weekly costs. I've set it up so that each worksheet is a week, with totals using =SUM. I want to transfer th...
Macro to create tabs and populate from other worksheets
SolvedI already posted this on the programming forum but have not had any responses as yet so I am trying here as it may be more appropriate. Current Set...
How to transfer lines of txt from one sheet to another sheet?
SolvedHello, I have an excel file that has 2 sheets of relevant information that I need excel to logically determine line up and from there automaticly ...
Repair excel files.
SolvedHello Experts, My problem is as follow: We're reinstall an Laptop With Windows 7, but the user does not back up a folder, This folder contained ...
How to remove image with vb?
SolvedHello, I have everything working but removing the image before saving. The code is not working and not even sure where to place it. (using excel...
Conditional formatting based on another cell; apply to rows
SolvedHello, I have two columns. Column A is for expiration dates, and Column B has a drop down menu indicating the status of an request (eg, pending, a...
Need help with date and if statement newbie
SolvedHello, I am trying to work out a formula if possible, to determine a date based on a date in another cell. So if the Date in Cell A is 3/1/2015,...
How to replace * with / in all formulas in an excel sheet
Solvedhi Guys, does anyone of you know please how to replace the multiply sign with a divide sign in all of the formulas in an excel sheet? I could not f...
Time calculation (timexnumber)
SolvedHello, i want calculate the salary of workers like the following example. worker No.1 salary/hour 1$ working hours this week 3:45 (3 hou...
Conditional formatting with range
SolvedHello, I have a little bit of a problem, I want to mark a cell in a range that is equal to another cell in different range, I can't figure it out....
If/or formula
SolvedHelp please I need to look up a cell and if it =1 return 1, =2 return 0.6, =3 return 0.4, = 4 return 0.2, if >4 return 0.0 for example A B ...
How to repeat a row 4 times, while increasing sequence
SolvedHello all, I need help on the best way to repeat this 4 times, and then increase the number at the end. I need this: Column A AAA_BBB_0002135 ...
Converting rows of data in notepad to columns
SolvedHello, Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains firs...
Conditionally copy columns
SolvedHello, I have a table with thousands of rows of text. Column B has errors in the data which I have fixed in column C (has many blank cells). I would l...
Change a range dynamically - vba script.
SolvedHi everyone. I am stuck on a small problem with writing a Macro in Excel and would appreciate some help. I have the following script: For...
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 ...
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...
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...
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...
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 ...
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...
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...
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 ...
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 ...
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 ...
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...
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 ...
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 ...
