Excel Forum
-
Excel returns FALSE sometimes.... why [Solved/Closed]
I'm using this formula to show the persons age based on date of birth. In some cases it works but in others it returns FALSE. If I change the date...
-
Date Formate Issue [Closed]
Dear Friends i have one column of Date in A1 cell issue is diffrent date formate in Column A1 and i want convert in one formate shap Expample...
-
Transfering data [Closed]
I have a charts with 2000 lines a colums of first names, a colums of last names, 3 address colums. I have a similar chart on a second sheet....
-
Help with VBA Code to Copy and Paste Data Needed [Closed]
I want to create a worksheet and copy and paste rows with a specific value in Column A to a worksheet named for the value. The new sheet should...
-
excell automatic filters [Closed]
Dears kindly i need fourmala to do the following i have a sheet have column A & B& C A have 3 different value (type1 ,Tybe2 & Tybe 3 ) and...
-
Excel 2003 IF Function using Dates & Text [Solved/Closed]
Hello, I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the...
-
ms office entreprise 2007 browse folder probl [Closed]
when am installing ms office entreprise 2007 it shows browse for folder ....i cant do anything plz tell me friends I already formated my system...
-
IF Function return FALSE [Closed]
Hello anyone, I need help on my formula. I use an IF formula but if the cell shown zero it returns false. the formula is like this...
-
Conditional Formatting: column A based on text values in columnB [Closed]
Hi, I am trying to figure out a way to use conditional formatting to highlight the cells in column A based on the specific text in column B....
-
Help comparig data in two different excel spreadsheets [Closed]
Hi. Im a little overwhelmed. i have one spreadsheet that i keep that has my 125 contracts and task orders on it. example: row 1 contract...
-
multiple processors for Excel [Closed]
I work with very large spreadsheets in Excel on a Mac and I often have to wait for Excel to execute things like sort and fill. I'm hoping too...
-
auto generate invoice number Save and Clear [Closed]
I'm new to this site. I'm using excel 2013, I want a macro to auto generate invoice number, at the same time when I save it should copy and...
-
If... Then [Closed]
Greetings all, I hope I can explain this correctly as this is my first time asking questions on a public forum. All me to set the stage....
-
Format fill colour based on another cell [Solved/Closed]
Hi I would like to format my excel page so that the rows alternate between two fill colors based on whether two cells are equal or not. Here is...
-
calculating text to result certain text result [Closed]
hi, if I enter S into cells a1 & b1 & c1 I need cell D1 to result 'CO'. if either cells a1,b1 or c1 has NYS entered into either cell or all 3...
-
Search values in one workbook and paste into another workbook [Closed]
I have to paste monthly figures from one Excel workbook to another workbook I want to write a code that search for the departments name within...
-
Transfer cell data from one workbook to another workbook [Solved/Closed]
I am using two workbooks to track account spending for quarterly reporting. Workbook 1: Day Expenses Workbook 2: Monthly Expenses WB1: I...
-
Question about my if statement [Closed]
Hello, I have an excel file with portions of addresses and i want to take the city state and zip code and put it in a separate cell. For that...
-
Date format change in excel [Solved/Closed]
Hi, I have an excel worksheet with a date column in the format m/d/yyyy h:mm:ss AM/PM. How can I change it to the format d/m/yyyy h:mm? I tried...
-
Extract data from one workbook and paste into another workbook [Closed]
We receive a workbook with various different sheets every month. We need to copy data from the workbook we receive into the workbook we use. We...
-
Macro to cut data from multiple worksheets [Closed]
Hi guys need help with a macro Scenario Have 3 WorkSheets (TEB,CEB,LTE) in a workbook called Cases All worksheets contain same Column Names I...
-
Applying conditional formatting to Rows that vary [Closed]
I need to have AA turn red when the date is out of window of AB and AC. I have dates in column AB and AC the dates are all different in each...
-
Date formate [Closed]
i have 2 date formate example 06/11/2004 07-01-2004 and i want 1 formate and i useing this function =text(CellAddress,"DD/MM/YY") and...
-
numerical value is range of cells has a text value [Closed]
Hi guys, This is for a holiday rota. if any sell has a 'h' in it I would like to total up the h's in a cell at the end as a numerical value of...
-
Macro to create a sheet and copy rows into that newsheet [Closed]
Hi everyone, I have a work book with 3 work sheets. Each work sheet contains 12 similar columns How do I write a macro to create a new sheet...
-
Excel Macro to combine multiple values [Closed]
Hi All, I am new for Excel Macro. Need to create a macro to get below attached data. InPut - Output - Please help me on this to...
-
Sum range if 2 conditions met [Closed]
Hi, I have arrange of numbers which I would like to sum in a certain cell, only if a column contains certain text and another column contains...
-
Macro to add certain cells to another worksheet based on cell $ [Closed]
Sorry, I know this has been covered a million times, I've looked up probably 30 different examples that look very similar to my situation for a...
-
IF FUNCTION FOR DATE RANGES [Closed]
I need to know how to do an if function: If D2 is >= 9/1/2008 and E2 is
-
Formula Help to Add Columns that Contain Text [Closed]
I want to add the total of Column A (going to be text) and Subtract Column D if there is an "x". How do I do that formula? Anyone able to help? ...
-
Hi All can you help me with the formula i require below [Closed]
Im looking for a formula that will look at a number in row b and if that number is 1 will add 1 day from the date in row c and put it in row e,...
-
Excel - creating reminder pop up based on criteria [Closed]
Hello, may you please help me in creating a reminder to pop up for every 5 hours once for a cell range having text equal to "pending" I was...
-
Using a macro to Copy and paste special values to a new workbook [Closed]
HI, I have a lot of financial data that is downloaded from a specific program with code. I want to be able to go and select multiple tabs in one...
-
Help: Return day of the week [Solved/Closed]
Hello, I have checklist sort of form that I am printing every month to let them sign for task everyday. from C3 - AG3 it is numbered 1-31...
-
Generating Individual Reports From A Master Sheet [Closed]
Hello everyone, I have a master pay sheet I am working on. I created a macro to create a 'pay summary' breaking down deductions, credits, etc....
-
Excel - Repeat rows to a specific number of times [Solved/Closed]
Hello, Hi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the...
-
How to copy sheets from one work book to other [Closed]
Dear Team. My query is Iam having two workbook in d drive as 1.xlsx and 2.xlsx i want to copy two sheets from 1.xlsx and paste in 2.xlsx...
-
Macro to add down a column [Closed]
Hello all, I need a macro that will sum numbers down a column until it gets as close to 8 as possible. ex: 1 .5 .5 4 3 .5 3 2 ...
-
nested formula with 'or' statement [Closed]
Hi, I have formula IF(ISBLANK(A3)," ", C3-TODAY()), which works absolutely fine but and i want to include another argument on it so that if value...
-
Sumproduct gives me error [Closed]
Hi, I am using the below formula, but it gives me error. Any ideas why is that? I really should work same as the countif formula but instead it...
-
Find Text In one Cell, Add Different In Another Cell [Closed]
Please be aware, I don't have much hair on my head to begin with and really don't have much to pull out either.. I'm frustrated. I've tried...
-
Excel [Closed]
Hello, I want to transfer a single cell of information (which is a number) from an external excel sheet to another excel sheet. I dont need...
-
Moving columns based on text [Closed]
Suppose data is like this: 3 3 OPG 4 5 2 5 3 MCG 0 4 3 0 4 ELG 4 2 4 7 5 CTG 4 2 1 I want a...
-
How to do recursive searches in Excel [Closed]
Hi, I have two worksheets. I need to be able to traverse a column in the first sheet and for each cell, compare it to a cell in the second sheet....
-
cell auto filled with dots [Solved/Closed]
Hello, I sow it once but not sure where and can't work out how to do it. Basically, if I write things in excel, I need it to be auto filled...
-
tracking 3 columns of scores between 1-10: OSAT, Arrival, Staff [Closed]
I am excel illiterate so please forgive me... I need to create a formula that will go out and look for a set of initials, take the data...
-
Automatically transfer data from one sheet to another [Closed]
Hello, I have a workbook in sheet1 details of materials issued to dealer for job work Sheet1 Columns: Dealer name, Date, Challan No, Item, Qty,...
-
How to copy data from one excel table to other [Closed]
I have two sets of excel tables. The master table has got several columns with heads defined. Similarly, the row heads have also been defined....
-
Compare text cells [Closed]
Hello, I need to compare text cell and return me column title- row 4 I have made this...
-
error in date formate [Closed]
find attachment of date format issue .......how resole the error please let me know
