The discussions
How to add times in hour and minutes format
SolvedHello 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...
Formula:if e18 = 1, 2, 3, 4 or 5 then end result = g18, g19 etc.
SolvedTrying 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...
How do i add text to a drop down list
SolvedGood day how do i add text to a drop down list i created in excel Configuration: Windows XP / Chrome 24.0.1312.57
Excel help
SolvedI 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...
Conditional formatting help
SolvedHi, 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 ...
Conditional formatting with "contain".
SolvedHello...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...
Ms excel number format error
SolvedHello, 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)
SolvedHi. 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...
Excel date format
SolvedHello, when users enter a date in excel using this format 12.1.2008, I need the cell to automatically change the format to 12-Jan-08 thanks, mo...
Help with text & number rule!
SolvedI wonder if anyone would know how to create the following rule in Excel: IF I enter a specific "text" in cell A, then Excel would insert a correspo...
Applying my macro to a range of cells...
SolvedI found this macro and it works perfectly....inserts an "x" on a single mouse click into cells, but I only want it active on a certain range of cells....
Date function
Solvedi want to know how to create a date series in an excel.. for eg if i enter the date in A1 as 1.12.2013 how to create automatically in the A2 as 2.12...
Moving data from rows into columns for every
SolvedHello, I have data in a single column and would like to transpose it into a row for every three rows with a space delimiter, for example; The colum...
Excel macro: combine selected rows
SolvedHello, I have source data in Excel looking like this: CustomerID SalesMonth SalesAmount 12345 Jan 15...
Sum ifs function in excel
SolvedIs it possible to have a criteria range for a range of dates and have it add for a date less that the specified criteria? 11/1/...
Invoice no
SolvedHello, After Long period i came here to ask some thing to my friends that is i want to raise the invoice as per the cell value i have given some e...
Bank reconciliation
SolvedHi Am trying to automate bank reconciliation Any ideas as what the code is. In the work book i have 12 worksheets for receipts and 12 worksheets ...
Macro for linking two workbooks, comparing one document id with
SolvedHello, I need help in creating a macro for linking two workbooks, comparing document ID's in one workbook with the status of that Document ID's in ...
How to delete a line from excel cell
SolvedDear all How to delete a line from every cell in a column??
2010 if function help
SolvedI'm looking to combine a IF function for one cell with a date function in another. The aim is to have something like this: =IF(A1=2099,"James Jones...
Iam trying a lot to make the formula succes, but its not helping
SolvedHello Ther!! Iam trying a lot to make the formula succes, but its not helping all people ther Kindly help me on the below formula it gives resu...
Dating problem!
SolvedHi Can you help? I need a cell to only input if a lead cell is blank but if the lead cell has a date format i.e 24/11/13 then to input that sam...
Hide/unhide an autoshape or picture in excel
SolvedHi All, Could anyone tell me the method to Hide/Unhide an Autoshape or Picture in Excel Spreadsheet? I know it is possible through Macro Codes, an...
Nested and/if statments
SolvedHello and good day. I am in the process of putting together an annual bonus/vacation accural sheet and need some assistance with building a comple...
Excel worksheet auto generator
SolvedHello, i have a workbook with a names sheet that has all the info I need put onto timecard and a master sheet with the timecard that the employee wil...
Need help with lookup? or if? command
SolvedHi Everyone, Can someone help me with a command or macro that will look up the price of a product in a country from a reference worksheet and then fi...
Compare cells of two columns excel 2007
SolvedHello, I have two columns with identical cells and I need to find those that are not the same. For example: Column1 Cell1 = "a", Column2 Cell1 = "...
Conditional formatting
SolvedI need a formula stating that if cell R7 is blank, then Q7 is yellow. So if anything is entered in R7 then the cell Q7 is no color
Need macro- copy row and insert 10 times
SolvedHello, I have a similar question as this previous thread: https://ccm.net/forum/affich-107673-copy-row-and-insert-n-times but I'm not sure which ...
Excel vba
SolvedHi all, Greetings, could I get help, I am trying to write data into cells in a spread sheet, using an initial value, then adding a specific increme...
Yes or no...if so....
SolvedHi I need to ask a cell to do two functions. So if a cell (drop down list) has yes/no...then another cell will.....when yes is selected then d...
Converting rows of data into columns
SolvedHi everyone, I hope you all can help. I have a file in with 17,000 lines of data in rows that I need converted into columns. I don't work with Ex...
Macro to traspose data
SolvedHi I need a help I need to transpose my data following way for a longitudinal analysis; ID Day1 Day2 Day3 Day4 Day5 Day...
Want one cell to be highlighted if i type something in next one
SolvedHello, I want B1 to be highlighted as green if i type any text in C1. Please help me. Regards Saurabh
Conditional formatting a single cell based on another range
SolvedI have been trawling around looking for a solution to my problem. I need to highlight/colour a single cell when its value appears in a row elsewher...
Conditional formatting a cell if a certain word is met
SolvedHi I am trying to conditionally format cell B3 if the criteria in cell C3 = NAT I am able to do it if it was a number but not if its a word, If the ...
If formula showing date
SolvedHi all, I created a spreadsheet that has a date in and a date out columns, the dormula I use on the date column is: =if(d2,TODAY(),""). Formula is in ...
Excel vba: application.filesearch error
SolvedHello everyone, I encountered error "Object doesn't support this action." when the program the line "With Application.FileSearch". Here is my codes...
Conditional formatting
SolvedHello, Does anyone know if you can set conditional formatting to highlight an entire row if the date in a specific cell is less than a week from t...
If data matches in one column, check 2nd column matches
SolvedI've been trying to figure this out for days, I'm sure it's possible but can't get it to work. I have a set of data - in one column there are refer...
Help to convert a date to julian date fromat yyyyddd in excel
Solvedhi, i have thousands of dates in format dd-mm-yy that needs to be converted to julian date format yyyyddd. dates that needs to be converted are fro...
Is there a way to call out multiple values in single cell?
SolvedHello everyone, this is tricky and im not sure if i have missed something or if this is even possible, if it is it would be a huge help. I am limited ...
Due date reminder in excel 07
SolvedHello, dear all. I have a "credit list" worksheet having the details like. 1) date 2) invoice number 3) name of beneficiary 4) total amount 5)paid c...
Ms excel, lookup word from a cell
SolvedA B C 1 C287198 MARIQ BLDG MATERIAL TRDG C287785 C287785 2 C2...
Excel formula
SolvedI have a blank excel invoice that I want to be able to type the Item number on it and have it populate the vital information on it like the item name,...
Need help please: excel click timer to time each work/task
SolvedHi Excel Pros, This is my first time to join the excel forums and have seen how helpful you guys are here. I need to come up with a visual basic...
Copy multiple charts to multiple worksheets
SolvedHi I have a challenge for which I cannot correctly conceptualize a workable solution so I am hoping someone here can share their thoughts on it. ...
Excel macro: rename all worksheets
SolvedSo, I'm trying to figure out a way to rename all the worksheets in a workbook. the first worksheet would be "1" (without the quotation marks) and c...
Excel macro help, hiding columns
SolvedSo I'm trying to figure out an Excel macro that would hide row A-K on every worksheet in a workbook. Thanks for any help
Need help to create an excel macro (combine columns)
SolvedHello, Inputs Col A and Col B ( all data ranges are variable), need out put in C Col. (MACRO), I not good at vba/e , kindly help. Col A ...
