1
  • Microsoft Excel: Count number of distinct values in a range

    In my Microsoft Excel spreadsheet, I already have a large table with several filters. The only other thing I would like to add is a summary (underneath some columns) that contain the number of distinct values for that specific column. Is there a formula / function that would allow me to do that?

    ITKE54,905 pointsBadges:
  • Excel Macro to extract substrings from a comma-separated string.

    How can I write an Excel macro to exctract substrings from a comma separated string located in a single cell and put each substring in a cell of a certain column.

    Sdsdsd15 pointsBadges:
  • Use of the EXCEL formula function to copy data and insert an asterik on both ends of output.

    Is there a method to use the formula function to copy the contents entered in one cell (A2) into cell B2 with the addition of an asterisk '*' on both ends of the copied text? An example being - Enter 'H123456' in A2, with the output in B2 being '*H123456*'

    Tmdillon5 pointsBadges:
  • Excel formula to find and replace letters in a word

    Hi, I have a cell that has a word written in it ex. damascus. Now with this formula, I need to be able to find the "a" and replace it with "A" so it will become dAmAscus. Is this possible?

    Microbert25 pointsBadges:
  • Excel equation

    When working out an equation in Excel, if I use a comma, it will work out the equation for me, but if I use a full stop or point the formula comes up with a #value error sign. eg. =4,5*5=22.5 but =4.5*5=#value Is there a setting I need to change?

    littlebiscuit25 pointsBadges:
  • Excel 2010 Second drop down based on first, not working

    I have tried a number of different formulas and data validation scenarios but I have not been able to get my second drop down to recognize the choice in the first drop down. I have a chart of sizes (including fractions) and several weights for each size. I want the weights in dropdown 2 to be only...

    jacktal5 pointsBadges:
  • Excel

    How do I find the sum in an Excel spreadsheet?

    Keteleyne1215 pointsBadges:
  • Cell formula

    I have a simple 2 column balance spreadsheet. I have my starting balance in column E Cell E4. I want to have a running balance in Column E. Column D has deduction amounts from balance in Column E. I have entered formula =(E4-D5) in cell E5 but this automatically enters the same starting balance...

    Schwenky5 pointsBadges:
  • Number formats

    I pasted a bank statement into Excel but I can't successfully do any calculations. Can you help?

    commercial5 pointsBadges:
  • Excel formula program

    Hi, I'm trying to do a table where I need to calculate how much commission I'm paying for a company. Before 35,000, I pay 35% commission after 35000 I pay 10%. The formula I have right now is =(IF(F9>=35,F2:F8*0.1,(IF($F$9<=35,F2:F8*0.35)))) and it works, but... I don't want the whole column...

    natmail10 pointsBadges:
  • Excel conditional formula

    Hi all, I can write a basic conditional formula such as =IF(A1="23", "OK", "NOT OK"), but I want to add a supplementary condition ... For example if A1 is 23 and B1is 24 then the cell will display OK or NOT OK as appropriate... both conditions need to be met. TIA, John

    Johnaldo160 pointsBadges:
  • Calculate overtime in Excel

    Hi All, I need to work out if the time captured in my AmendedDate column falls outside normal business hours. So basically I am reporting for a Call Centre, which logs support tickets. In my Database I already have a created Date (when the Ticket was Issued), AmendedDate (When the technician made...

    BigJoe2350 pointsBadges:
  • Find and replace formula in Excel

    Hi everybody. I am forex and options trader. Options contracts look like this: 'GOOG 121005C770" or "GOOG 121005P770". I need to have a formula that can lookup the cell and if contains "*******P***" to replace the whole cell with "Put" and if the cell contains "*******C***" to replace the whole...

    Eillimasood10 pointsBadges:
  • Function with hours & minutes involved

    Any ideas on how to do the following: I have a payroll spreadsheet that has columns that show the clock in and clock out time that I formatted the cell to give me miliatary time.  I then have a "sum" column that subtracts one from the other to give me thetotal hours/minutes worked.  I have two...

    Coxesoflb5 pointsBadges:
  • Creating a list in one Excel cell by referencing several other cells

    Using excel and I am trying to make a list generated into one cell, or cells right under each other. I have 85 choices for the user to select. If the user selects a symptom (column b, I want the treatment (in column C) to be displayed on a different tab. So the user would go through tab one and...

    Adventuredev55 pointsBadges:
  • Paste values over a formula on condition of a column in same sheet

    Hi, I need to create a macro for my spreadsheet. I will try to attach a sample of it if required and if someone can tell me how to do it. This may aid my description of what I want to do. Basically I need to run a check which does the following: If J2 = “X” – then select F2 and paste special...

    Cmb8010 pointsBadges:
  • Microsoft Excel subtraction using VBA

    I would like to have some coding in vb related to subtraction in Excel sheet.I have 2 sheets.I need to take data from 2 cells from the first sheet and perform subtraction and then placeresult in sheet2.I have huge amount of data in sheet1.I need to perform this operation with all the cells in...

    Devisri20 pointsBadges:
  • How can I find an Excel formula that helps me change text?

    How can I find a formula that helps me change letters in typed words without the daunting task of retyping them again? For example, I typed (in a table) 100 words ending in -d, and I want the same words just without the -d or with -s instead. Or can I join letters to form different words? Copy and...

    Ja555you15 pointsBadges:
  • Multiple VLOOKUP with multiple results

    There is 3 sheets 1st master sheet,2nd B-1 & 3rd B-2.In (master sheet) column A there are repeating towers name (eg:B-1,B-2,B-1,B-3), column B there are repeatation of apt. no. (eg: 101,102,101,103,104,102), column C there is a amount(eg: 15000,20000,etc.), i want to give formula in each sheet to...

    Excelaccountant20 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following