Excel Forum
-
fill amount from a cell if date is before end of month [Solved/Closed]
Can someone please help. I'm trying to track outstanding bills due by the end of month as in the following example: If date in cell B5 (due date) i...
-
Excel Referencing [Closed]
Hi Experts, I am having the following columns in the excel AA BB CC REQ_3.1_1 REQ_4.1.1_2 ...
-
convert number to words in excel [Closed]
----------------------------------------------------------------------------------- there is some problem while we convert number to words ............
-
Macro to copy the same values between 2 sheets to a new one [Closed]
Hello all, I'm not very familiar with macros in Excel and I hope to find a solution. I need a macro that works with 5 sheets (sheet1,2,3,4 and 5)...
-
Run time error 424 [Closed]
Hello, I'm new to VBA. I've tried everything I can think of to avoid receiving run time error 424 when I try to run the following. Any help is much ...
-
if sheet 1 column 4 says hol then it fills in columns A1,B1 and [Closed]
Hello, I have 2 sheets in excel 1st sheet has: 1st column has employee Team A1 2nd column has employee number B1 3rd Column has Employee name C1...
-
Excel- how to sum specific data [Closed]
Hello, how can I sum only specific cells together? Column A - Regions Marche Puglia Lombardia Emilia-Romagna Lombardia Puglia Trentino-...
-
nested if function with minute and time function [Closed]
hey guys. so i have this problem which is to write a formula to calculate the cost of minutes used in a computer shop. here are the conditions: ...
-
calculate date and format without showing both number and date [Closed]
Hello, I am trying to enter a line item in an invoice that states the Week ending date like this "HOURS WE" then states the date on the invoice (F2 w...
-
Find highest value and state its cell name [Solved/Closed]
Hello, I have the following issue: in A and B: Marche 160,994 Puglia 463,251 Lombardia 405,626 Emilia- 542,009 Lombardia 451,468 ...
-
Copy the data in filter [Closed]
Hi, I want to know that how can we copy the certain data in filter? Help me someone Please..........
-
How to extract Date in a string [Closed]
Dear Friends, I need your help in extracting data in a string. Example : Student name , Class, section, DOB, Address, email ID. Sachin...
-
dates using "/" (slash) changing into "-" (hyphen) [Closed]
I have 2 serious problems. 1. When i format dates using "/" (slash) in my system and open the same excel file in another system the separator is ch...
-
Excel Vlookup ... Problem [Closed]
Hi,i have 3 columns(Ticket Number, Site ID and Date), i need to copy Site ID and Time according to the Ticket Number from 1st Excel sheet to 2nd exc...
-
Changing the day in date by default [Closed]
Hi, I want to know that how can we change the day in date default by dragging down? Best Regards, Drakshayini
-
moving data from column to row [Closed]
Hi All, Please help me with the macro code for pasting the column data(which is shown below) to row. Data is have like this A Cell B Cel...
-
search for a string and if found, select that row? [Solved/Closed]
I know this is a very simple question but I can't find the answer I need. I am using Excel 2007 but I can get to a computer with Excel 2010 if necessa...
-
Re: Financial Modelling [Closed]
Will appreciate any advise on the best approach to doing financial models for established companies and start-ups trying to raise venture capital fund...
-
MS xl formulah [Closed]
how to show conditional result in another cell in ms xl? for example, if A2 is >5% then the result would be 20 in B2
-
How to add times in hour and minutes format [Solved/Closed]
Hello In the first column I have start time, in the second finish time and the third column the time elapsed ie A minus B = C But if I add colum...
-
I want to find the student Grade [Closed]
I want to find the student Grade My formual is : =IF(OR(C12
-
Copying text from sheet 1 to sheet 2 in same workbook [Closed]
Hello, Greetings everyone, I am a new user here. I wondered if anyone could please help me with copying text data from sheet 1 of a workbook to...
-
coming and out going time [Closed]
I ampreparing in excel with in coming and out going time,But for the average time i am taking as for 5 hours a day,If any employees works for more tha...
-
Getting multiple values out of one cell [Closed]
I trying to copy into another cell data from 1 cell that has multiple values that are seperated by blanks. Example a1 has 123 456 789. I used the ...
-
"COUNTIF" function for day of the week format [Closed]
I have a column of dates, where the formatting I've set for "Day of the week, month, day, year". How do I run a COUNTIF function for Mondays, Tuesd...
-
Extracting Name from column [Closed]
I would just like to extract the name from a column: 224. Can someone help me do that?
-
Conditional format based on cell containing function [Closed]
Hello, In column J3:J32 i have functions that determinates grades (=IF(I3>=90;"10";IF(I3>=80;"9";IF(I3>=70;"8";IF(I3>=60;"7";IF(I3>=50;"6";"5"))))))...
-
changing date format in excel [Closed]
I have imported dates in an excel spreadsheet from WinQs.sql and opened the file in excel. the date format is 07/11/2009 but I want to change the dat...
-
Macro [Closed]
Greetings, I use peachtree accounting software and we have no option to export reports in excel. can i record macro to pull data from application? ...
-
Formula:IF E18 = 1, 2, 3, 4 or 5 Then End Result = G18, G19 etc. [Solved/Closed]
Trying to create a formula where I have a merged cell (E18) that if 1, 2, 3, 4 or 5 is entered I want the end result to equal the contents of G18, G19...
-
Conditional formatting with values [Closed]
Need some spreadsheet help. I need the value ($'s) in Cell A to become RED if Cell B is greater than Cell C. Make sense? So... If my actuals are...
-
store the values in next sheet [Closed]
Dear All, I have doubt in xl sheet, I have two xl sheet , i show the first sheet parameter as below, CABLE NO -1 LOAD -18.5 VOLTAGE -415 CURRENT...
-
how do i add text to a drop down list [Solved/Closed]
Good day how do i add text to a drop down list i created in excel Configuration: Windows XP / Chrome 24.0.1312.57
-
generate payslip [Closed]
Hi, can any one help me to generate payslip? I have a master sheet with all the details including (basic, da, OT and other things). I do have t...
-
Partial Match issue [Closed]
Hello, I was searching for a formula for the partial match of the cells (for companies;for let's say 20 characters) and highligt them for 2 column...
-
Excel help [Solved/Closed]
I am tracking shipments of our product. When I enter the amount that shipped, I would like for that days date to appear in a separate cell and never c...
-
Vb, how to copy values & repeat to next 50 cells [Closed]
Hello, Need help writing code @ step C & D I am: A) copying values in E1-E4 & transposing values B) to Col. A next available empty row (obviousl...
-
Conditional formatting help [Solved/Closed]
Hi, I have a spreadsheet with a column for employee hours. Anything over 9 hours is considered overtime and we are tracking how many employees are ...
-
Macro Hyperlinks [Closed]
hello i already have this code in my macro that works fine s ub New_Personal_Profile() Dim MyCell As Range, MyRange As Range Set ...
-
Clearing a single Cell without deleting the contained formula [Closed]
Hello, this is my very first try at using a formula for help (so please be patient with me if I make a mistake:) I have a growing knowledge of Excel ...
-
presenting data from one worksheet to another by dropdown menu [Closed]
HI All, I have a worksheet with two colums of data. On another sheet I plan to present the data in an easier to read format. What I want to do i...
-
map column names to their short names [Closed]
hi all, i am trying to copy and paste columns like application id,application name,number in a worksheet in workbook1 to another worksheet in workboo...
-
Conditional formatting with "contain". [Solved/Closed]
Hello...I am using Excel 2007. I can't get beyond the following: =ISNUMBER(SEARCH("campaign",A2))=TRUE This is what I'm trying to do...If cell A2...
-
Look to find a formul that will make an item rec [Closed]
Hello I am looking to track items received... I would like to build a box were we enter the NSN and the amount of the items... Date auto populate. ...
-
MS Excel Number format error [Solved/Closed]
Hello, I use Ms Execl in that I have a error it like this..... 1. when I type a number 400 in the cell an give Enter. It is not showing the exa...
-
Date format problem (5.8.14) [Solved/Closed]
Hi. I'm using excel 2013 on Win7 Ultimate SP1. My problem is that I often type the dates with the help of decimals/periods. But I've learned thru goog...
-
Create new sheet and copy data from input page to the new page [Closed]
Hello Every One, I am a basic excel user. I am trying to create an excel data base that will keep a record of employee duty hours, dates and types...
-
add "x" based on "Y" lines and copy [Closed]
Help! I have a spread sheet that is over 8,000 lines and I need to insert and copy lines based on a value in "y". Also then add a blank line under the...
-
I am a computer opertor but i still need Excel! [Closed]
Hello, need your help please!!! Configuration: / Opera 9.80
-
ages and difference between them in years:months [Closed]
Hi, I would like to enter data in the form 12:06 meaning 12 years and 6 months and then work out the difference between two such cells with the an...
