excel functions

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...

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.

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...

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...

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...

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...

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...

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

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...

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

<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,

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...

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...

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...

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...

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...