The discussions
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...
Where can i get ms office publisher for free
SolvedHi, any body can help me, where I can to get MS office publisher for free?
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...
Hacked e-mail account
Solvedhow to retrieve my hacked hotmail account. I tried 3 attempts by using the Microsoft forms to reset my password but it failed. Missing some security ...
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...
Update of outlook, and after that i cannot receive or send mails
Solved/ClosedThe computer made an update of Outlook, and after that I cannot receive or send mails. I get the message "Not implemented" when trying. I have the sa...
Pdf to word or excel
Solved/ClosedDear Sir/Madam, Can I know about the software and it can support our alignment if the text or images in PDF changes to word and it doesnt get align...
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 ...
Compatibility
Solved/ClosedHello, I was just wondering if the free download for Open Office is compatible with Windows 8.1, as I did not see it listed. Thank you and have a gre...
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...
Possible to import pdf data onlin into excel?
Solved/ClosedHello, Does anyone know if it is possible to import pdf data from the internet into excel? Or do I need a special adobe acrobat program to do so? ...
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...
Add days to date
SolvedHello, I need a formula that help me to add days to Date and it gives me the result in date format For example 03/01/2010 + 25 = 28/01/2010 Th...
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)
