Excel Forum
-
Ranking sorting problem Closed
Hello I would appreciate some help on the following formula problem. I have a game where some teams have wins, losses and draws. My problem arises wh...
-
Copy & pasting the data into excel from an SQL Database file Closed
Hello, We have setup a database which inserts the data from an batch file and the data is extracted into an output file. The output file needs t...
-
Differences in two excel sheets Closed
Hello, I am trying to see if I can compare the first column in two different excel sheets to see if there are differences. Column A Book 1 ...
-
VBA code for duplicating Excel Workbook Closed
Hi all! My company use delay logs where we record delays everyday for different customers. At the moment every morning we're having to manually ...
-
Formula that can automatically classify monthly expenses Closed
Hello, i need a formula that can automatically classify monthly expenses. I want the amount to be transferred to the similar subhead automatically as ...
-
One million and two hundred thousand only Closed
I have try edit vba code in Excel for spell cu1,200,000 = One million and two hundred thousand only change in to One million and Two San only. please...
-
downloading Closed
Hi, can yoy help me how to download excel or spreadsheet using open office. I need it for my job. Thank you very much
-
Copy the data of a Row based on identifying the data in a cell Closed
Hello, I have data in about 20 columns and 100 rows There are some blank cells in column "I" (about 20 blank cells totally in "I" column, at di...
-
IF Function Closed
Hello, How many times we can use IF function in single formula?
-
CELL = YES or Other text return value Solved/Closed
Hello, I'm using IF statements to return a value for the specifc answer supplied for the question and then adding up all the questions for the t...
-
need to learn Excel how Closed
i need excelent in ms excel , how any ways ,suggestion or reference sites..i thank full to your help.
-
Use Excel color scale to do gradient with more than 3 points Closed
Hello, I would like to use Excel color scale to do a conditional formatting on some cells. If the cell value < 0 --> cell color is red If 0 cel...
-
Need to find a set of letters from a group of letters in excel Closed
Hello, I need to find a set of letters from a group of letters or words within a cell in excel. For ex, If the address is filled in a cell, I ne...
-
How to check % value in excel and macro using VBscript? Solved/Closed
Want to check a cell with % percentage format matches the value in Vbscript code. Sub ChangeColor() Dim lRow Dim myVar lRow = Range("AC" & Row...
-
Formula to copy rows a set number of times Solved/Closed
Hello, I have a delivery manifest that shows the amount of products coming in, descriptions etc. that we use to produce barcode labels. Unfortunatel...
-
Need vba code to export data to clsd wb shts depds upon sht name Closed
Dear experts I have master_file saved in local folder & workingfile i want run vba code to split unique data from column D:D from working file and ...
-
identify source of cells Closed
Hello, I've got a spreadsheet which reads cells from 9 other spreadsheets one of two tabs in a very large list. Other users copy and paste cells b...
-
vba copy data from a range and paste to empty column Closed
Hello, I have a set of values in range P6:P15. At the end of each month, I would like to copy and paste the data from the current month column to ...
-
Automatically transfer excel row to a different sheet based Closed
Hello, I have a spreadsheet for paid & unpaid invoices from our customers and would like to have the row automatically move once I mark it pa...
-
VBA Using subroutines - help please Solved/Closed
Ok guys, I have a problem (well more than one, but Im not sure I should mention those on this forum!). Im in the process of writing an Excel macro ...
-
windows 7 adobe player & Excel Closed
Hi How to download the adobe player new version for Windows 7 & Excel By mistake both have been deleted
-
sort Type and Size Excel formula Closed
Hello, can someone please help? I'm trying to write a formula that would sort Type and Size on the following spreadsheet which has the following: ...
-
Extracting matched observation and its corresponding row Closed
Hello, I have excel sheet containing around 100K observations (rows). There is one column say "A" containing some IDs and each ID is having 10 par...
-
Can't change format of cell Closed
Hello, Using Excel 2013. I have a document which consists of various combinations for padlocks in a format of 00-00-00 most come out correct...
-
T-Shirts Closed
Hello, I have 3 columns Male, Female AND Long Sleeve, I then have 7 columns of sizes 4XL, 3XL, 2XL, XL, L, M, S. If and x is placed in one of the 3...
-
conditional formatting Closed
I am creating a dashboard to monitor the metrics of several facilities. This spreadsheet has a summary page and each facility has their own sheet to ...
-
Explain formula Closed
Hi, please can anyone explain what excactly does this formula? =INDEX(Sheet1!$A$2:$A$13,SMALL(IF(FREQUENCY(MMULT(--(Sheet1!$B$2:$B$13={"jan","feb","m...
-
Date format nightmare Solved/Closed
solved with this: Because it is not a date to excel. 1. Select the column in which there was date 2. Goto data and choose text to column 3....
-
total number of text Closed
In column C, there are drop down values for Complete, Incomplete, and In Progress. I would like to put summary statements that say: The TOTAL number...
-
Matching Names Closed
Hello, I have two lists with names approximately 10,000 on excel. I want to find out if there is a formulae for near matches against the two list...
-
Pleas:Using a Macro to Insert one Picture into Cells in range Closed
Dears, I would like to ask you for help with following topic: I would like to insert a picture from file stored in my computer defined by name of f...
-
Using a Macro to Insert one Picture into Cells in range Closed
I would like to insert a picture from file stored in my computer defined by name of file from cell B2 to cells in range given by lines in C2 and colum...
-
Count multiple instances of keywords in a cell Closed
Hello, I have to scan through a column of text comments for certain keywords, and count the number of times these keywords pop up in each comment. ...
-
Automatic Key In Closed
Hello, I have 2 main sheets at play here: SS Order Order Placement SS Order is a supply allocation form that has loads of past records and ha...
-
Macro Help Closed
Greetings fellow users! I am in need of some assistance: Recently, I have created a macro in which I need to copy 100+ variables from one shee...
-
Excel sum value... Solved/Closed
Dear I would like to know how to do the below mentioned formula I have tried but not resulted. Excel - Sum value in column when cells contains ...
-
Macro Help Closed
I have created a macro in which I need to copy 100+ variables from one sheet to another. Due to various constraints, I have found it easiest to paste...
-
Not being able to find the range path..need help!!!!! Closed
Sub INSERT_PIC() Application.ScreenUpdating = False On Error Resume Next ' Macro3 Macro ' Macro recorded 22/05/2002 by SVK ' Worksheets("Pictu...
-
Insert and delete column with macro Closed
I have master data that need to be edit first, it contain many unused columns but not merger and i want to delete those columns after that i need to i...
-
Formula Help Solved/Closed
Can someone please help me with this formula =IF(G2="1",VSC410, IF(G2="2",VSC450, IF(G2="3",VSC470))) What i am trying to do is : if G2 has the...
-
Excel 2010: Adding rows based on value from other cell Closed
Hi, I see that similar questions have been answered many times but mine is a bit different. First of all, i would like to say that i am very new...
-
summing results from vlookup function Closed
I have a table with 5 columns. I am trying to use vlookup and a variation of sum (sumif) to compare the value in cell A5 to the values in cells A20-A6...
-
Conditional Formatting based on year Solved/Closed
Guys, I come again cap in hand with another plea for help on a sort of finished project, but I want to make it better. I have some conditional f...
-
How to Type in one worksheet and have it appear in another Closed
Hello, if anybody could please help me with this, I have 2 spread sheets. They are exactly the same except one is in English and one is in Spanish. I ...
-
How to type in one sheet and have it show up in another Closed
I have 2 spread sheets. They are exactly the same except one is in English and one is in Spanish. I would like to send the spread sheets to customers ...
-
SumIf Closed
I have a column E with dollar values. I have a column L with "y" or "n"; I'm trying to figure out a formula that could sum only the values in column ...
-
Extracting rows from excel Solved/Closed
Hi there, I have an excel sheet with a very large data. I want to extract different rows and write them in to different sheets of the same excel (or ...
-
Increment cell value based on change in value of another cell Closed
Hello, Say I have a value of 100 in cell B3 and I need this value to increase/decrease based on the change in value of A2. How do I do that? For e...
-
Excel Query Closed
Hi I looking for a formula that will calculate an average order spend by day without having to do this manually(1, 2, 3 ). So for example it tak...
-
Macro to Copy Closed
I am new to writing macros but need help in creating one to copy data from one cell to another with conditions. I have two spreadsheets merged from t...