excel functions

  1. markkeith

    Function or Formula to get a value for each cell from multiple logical test.

    I'm newbie to VBA and have limited knowledge in making complex formulas in spreadsheet so I'm having difficulty thinking of a better approach to achieve my desired results. I want each cell in multiple rows and columns to get a value of 1 or "" depending on the following logical test: If Name...
  2. P

    Generate random number between a predefined set of values without duplicate numbers

    How can i generate random numbers of certain string length with predefined set of characters and numbers ? For eg: Generate a 20 random numbers that only contains " 1 0 P K L @ " , of which string length = 18. Output1= 1P0PL@P01K1PK@L0P Output2= 1K11P@P0K@L0PP0PL . . . . and so on.
  3. B

    How to copy or filter by automation function?

    Hi everyone,:) Let say, I have a daily production related to 5 unique departements. (dep 1, dep 2, dep 3, dep 4, dep 5), . each of these deps, are manually entered in a table main master sheet on a daily regular basis. The required task is this: How can I get each of these...
  4. D

    Replace a blank cell with a string using if function

    Good day all, I have an uncommon challenge. I have a sheet named Sheet1 filled with data, I want a situation when I delete the values in a cell, instead of remaining blank, it will be filled with a string (example "x"). I tried using the IF function from Sheet2 to fill a blank cell in...
  5. R

    VBA Code or Excel Function For Multiple Sheets in a Workbook

    I know that there are probably threads that have answered this before, but I figured I'd start a fresh one as most of them are pretty old. I have a workbook that was given to me where each participant receiving quarterly payments has their own tab (50+ tabs). Each participant has their own...
  6. S

    Concantenation, Iferror and vlookup

    Hi guys. I need some help with utilizing excel functions. Specifically, vlookup, concantenate and iferror. This is the question that is eluding me. "The Preferred Purchaser Discount % (heading “Preferred Purchaser Discount %”) is allowed to certain favoured customers of the business. These...
  7. C

    Apply an excel function to a column in a matrix

    Hi everybody I'm looking for some help applying the standard deviation to one column in a matrix, I don't know the right way to define the range in this formula, so I will put an example for a better explanation of what I intend to do: Option Base 1 Sub Producto() ReDim c(6, 2) As Variant...
  8. A

    VBA code to call a suface function.

    Looking for VBA code/example to call the excel function "CELL(info_type, [reference])". :banghead:
  9. A

    Third Post - Problem Still not solved - Function needed

    Hi Experts, THis is my third post regarding the same issue. I have a list of 29670 URLS in a Excel Sheet. Example URL - <tbody> keywords=clubs&location=Ab10&searchType=manualexpansion&autocomplete=kw_recent&scrambleSeed=981534963&pageNum=1 In this URL Zip code is "Ab10" Same for all 29670...
  10. V

    Excel Built-in Functions Code Behind Them

    Hello everyone, Is there a way to see the code of the excel built-in functions? Are these functions written on VB language? If not, is there anyway to see how are they built? Regards, Verysheyn
  11. V

    Pull top 3 values and Row Headings

    <tbody> Players At Bats Batting Avg Mike 20 .345 Dave 18 .266 Nick 16 .121 Paolo 12 .215 Vince 10 .318 </tbody> I want to pull the Top 3 batter and their batting average. I can use the max/large functions, but cant get the index or offset to work. Thanks,
  12. H

    Nested If Function Contains Errors. Need help..

    I am trying to do the following with a value in P7 to print text in an adjacent cell based on the value in P7. I am trying to get the function to return as follows: If P7 <.95 return LVL 8 If P7 <1.06, but >.95 return LVL 7 If P7 <1.20, but >1.06 return LVL 6 If P7 <2 but > 1.20 return LVL 5 If...
  13. A

    Fill Adjacent Columns based on cell value

    Hello, I have string in column A. I input some numerical values (null -15) in column B . I want vba / function to look for the value entered in B and based on this value fill the adjcaent columns with string in column A by adding "_C" & "number" with the string in column A For example; I have...
  14. A

    Need solution for my problem ( Excel Formula )

    Hi Experts This is my first post so apology if i have done any mistake while posting the thread. I am looking for an excel formula to get the result. Data is provided in below table There are 3 criteria based on which a single value needs to pick automatically. criteria 1 = value 1 variable...
  15. P

    Extract First Name Last name

    Hi, I have data stored as Last Name, First name but I want to get it now First Name Last Name (no comma) Example- Data- Ho, Joseph zu-sien Required Result- Joseph zu-sien Ho Also the lenghth of each name would be different so can not use fixed number to get required result. Appreciate...
  16. S

    Formula Help - Generate new record number if name doesn't exist

    I am working on creating a membership database in Excel. I have separate pages for Memberships, Donations, Sponsorships, and Receipts (to be entered as we get them). I am trying to set up a formula, that matches the record number of a Donor when their name is entered into receipts. If...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back