The discussions
Round up formula for time
SolvedHi All. I need an excel macro to populate a cell with a time slot based on the previous column which is a datetime value. e.g. if column A is 1-Apr-...
The value of a name
SolvedHello, I've been playing a lot of dark souls 2, and I'm trying to make a spread sheet to have the value for armor (to start). I plan on making ...
Can the formula counta / count exclude 0 values?
SolvedIf I use COUNT or COUNTA, what can I include in the formula to exclude zero values? Thanks for any tips
Transfer data into invoice
SolvedSo I've put hours and hours into this with no avail. Here's my situation...I have on "Sheet 1" a list of materials which could potentially be used dur...
Inserting a row when the value of a field changes
SolvedI was using this code as a start but can't seem to mak it do exactly what I want. Sub InsertRows() Dim r As Long, mcol As String, i As Long '...
Format cell color based on date range
SolvedHi, this is my first post. I'm glad to be a member of this forum. Based on conditional formatting, how can I select a cell and have the backgroun...
Filtering data from 1 sheet to another
SolvedHello, I have the following problem. Kindly help me with the same: Problem statement: I have data pertaining to projects, milestones and tasks ...
To show blank record when no data while copying
SolvedHello, I have three sheets sheet1(Active) ,Sheet 2(Inactive) and Sheet3(Total). I have written code which would copy data from Active sheet ,th...
Add value to one cell if multiple other cells have any value
SolvedHello, I'm trying to create a spreadsheet where: if A1 has any value, 10 is added to the total sum in G1 if B1 has any value, 20 is added to t...
Conditional formatting for cells depending on other cells ranges
SolvedFirst off, I am not even sure if i worded my question correctly, so sorry if i have. What i want to do is... have for cells b4:b7 to have on green ce...
How to see if a particular cell in a table has date data or not
SolvedHello, I am preparing a tracking tool to measure the life of an item. The table has Installation No Date 1 ...
Highlight the linked cell depends on drop-down list choice
SolvedHello, I have a question. Let say I have a table containing number 1,2,3,4 and 5 in A1:A5. In another worksheet, I have "Student" in A1 and "Asses...
Conditional formatting: merged cell color
SolvedHi, This is probably an easy solution but for the life of me cannot get this to work. I have a situation whereby I have a line of information th...
Compare three columns contain same characters
Solved/ClosedI have three columns of form security access in an application for different classes. The security characters may be in any order. I need to compare...
Excel: partial matches in 2 different cells
SolvedHello, I've been mulling over this all afternoon and need some help. Here is what my sheet looks like: K L 3 ...
Determine percentage via formula
SolvedHello, can anyone help me determine a formula that will give me a percentage? If N11 is 2500 and I11 is 84, I need a formula that will help me determi...
Two values to find on the same cell
SolvedHi, Can the below be shorten up? It's basically to count if "dr" or "ba" are in cell E2180; =IF(ISNUMBER(SEARCH("(dr)",E2180)),"1",IF(ISNUMBER(SEA...
Macro to delete row after certain condition found
SolvedHello, I am an Excel newbie; I am trying to write an Excel macro that will search a certain column to find a blank value. It would then delete the...
If then (text or no text)
SolvedHi, I hope someone can help me with this. I would like to create a formula that says this: if a certain cell contains ANY text, then write "6.2"...
Connect two worksheets together
SolvedHello, I am trying to connect two worksheets together. If text found in one cell in sheet1, make the same cell on sheet2 different color. Ther...
Conditional formatting: highlight cells based on two values
SolvedHello, I have a merged cell (C5-N5) that I want to change the fill color, based on the combined input of two cell values. I'll just call it "C5" f...
Lining up group of cell values in excel 2007
SolvedHi I have two group of cells D6 to D8 and other G12 to G15 Need a code with two conditions that can line up the details of the mentioned cells in ...
Excel
SolvedHello i want to know how to convert date into words(english & HINDI) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April...
If date multiple conditions
Solved/ClosedHello, I need help with rewriting this code: =IF(A1DATE(2017,12,31),"2", IF(A1>DATE(2020,12,31), "1"))) I'm trying to categorize those date ...
Fill data according to other sheet's data
SolvedI have a sheet1 like this: r1 text1 text 1 r2 text1 textx 2 r2 text1 textx 0 r3 text2 texty 1 r4 text2 textz 1 r5 text2 textx 3 r6 text2 text...
Duplicate rows based on cell value
SolvedHi, Can somebody help me out with this. I want to duplicate rows based on input in a cell. can it be done in VB or macro or formula array? User wi...
Excel payroll work
SolvedHello, I'm using Excel to do payroll system. e.g. I create worksheet that showing data as below table :- basic more than 0.01 less tha...
Excel formular
SolvedHello Sir, Can you let me know the formula in Excel: I have a table as below: 1 A B ...
Excel greater or less than
SolvedHi all, I'm having a problem that with multi counting with less than, eg. case 1: A1 = 1000 (total revenue) B1 = 3% (rebate) C1 = 2000 (free ...
Create worksheet based on lists & populate data from another...
SolvedHello, I've been recently working on trying to create a fairly large excel workbook & trying to automatically populate sheets inside of it. I h...
Conditional formatting
Solvedhello I did a table in Excel ( its a vacation tracker) I'll give you an example for what i'm trying to do Ex : my vacation starts from 15-mar ...
Search column b for matching value from a row in column a ....
SolvedSearch column B for matching value from a row in column A and populate D with the value that is in the matching row of B that was in column C, ie XYZ ...
Compare column a to column b and return column c
SolvedHello, I have spreadsheet with names in Column A, phone numbers in Column B. Column C has the same names in different order. How can I ha...
Copying data from one sheet to another conditionally
SolvedHi gang, I have a spreadsheet with columns A thru H being populated with text. I need to copy columns A thru H from spreadsheet 1 to spreadsheet 2 i...
Highlight row on one sheet if a number matches on another sheet
SolvedHello, I have a spreadsheet with multiple tabs. I am trying to figure out how to get a row to highlight on the tab called "Directory" if a number in ...
How to define specific format for number?
Solved/ClosedHi, I would like to define specific format in excel. For example, if I type 123456789 and hit Enter, it should be 123-456-789 or 123-45-6789 autom...
If statement using date to change row colour
SolvedI have a sheet with the following header row: Reference Client MAWB / BoL Date logged Date completed Days to resolve Logged by Caller type Error ar...
Excel 2010-vb macro formula into many spreadsheets
SolvedHello Everyone, I am new in VB programming and I am trying to write a macro in Excel. Basically, I have written a formula in Excel which enable me ...
If function using dates
SolvedHi I am trying to write an IF function for an escalation calculation and need some help please. What I want to achieve is to have a date filled ...
How do i change the result of a formula to normal text or values
SolvedHello , i have a formula which calculates my working hours for each day " =C9+(B9>C9)-B9 " ... when i try to sum all the hours resulted from that for...
Excel mmyy format in order
SolvedHello, I have a data set and a column currently with a selection of dates in MYY and MMYY, eg. 909 (Sep 2009) 1011 (Oct 2011) 1212 (Dec 2012...
Excel formula help
SolvedHello, I would like to request some assistance with a formula I have been trying to figure out. I know it's a simple one, but it evades my mind. ...
If cost is 18.66 what would be 0.6% of it (calculation method)
Solvedand if basic pay 65000rs what would be the 2.5% of it(calculation method)
Formulas
Solvedsum a column if two other columns contain a specific text each so sum (if (A1:A20=1 and B1:B20 = "A", C1:c20)
Copy data from current work to another
SolvedHi All, Please can you help me with the VBA code which copies columns from current active workbook to another closed workbook at the end of rows.....
Conditional formatting from another cell by range
SolvedHey, I need helpppppppp i want to change the color of a cell based on the range value of another cell eg. i need a1 to be red if b1 is < 70%, Y...
Excel formula
SolvedI need a formula to compute one equation if one criteria OR another criteria is met, and a different equation depending on another criteria If nu...
Code to move a row based on fix values and paste it
SolvedHello Gurus, This is my 1st question and I m a beginner in macros .I wanted a code to move a row based on a fix values and paste it in the same shee...
Simple macro
SolvedI am trying to create a Macro to filling in a series of columns starting with the current cell. simply if cell A1 is selected and you hit the ...
Fill amount from a cell if date is before end of month
SolvedCan 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...