results

Good morning. I have the below information and I am trying to find a formula to complete column U. Cell B1 and B2 play a role. Basically, I would like the formulas in U5:U7 to look at the period between the effective date (column B) through the min of either the Current Month end (cell B1)...

I'm currently using two formulas that works great. Thing is.. I'm combing two columns C & D w/ =C2&"-"D2)for the search on DISPO! Sheet. Searching through "J" and finding a match on Sheet (Key! returning results from columns 2 & 12 . It doesn't return correct result when the combined =C & D...

Hi everyone- I’m looking to develop a formula that used a two-factor formula to find results that will be listed out in one cell. Here is a snapshot of a file I have created: https://imgur.com/a/4Kc4tZN Along the top are a list of services. Along the left are a list of features...

Hello, I need help transferring results from one sheet to the master sheet. The users are only listed once on the master sheet, but some users have multiple results. Vlookup only returns the first value so I need help getting each thousands of users results in one cell in the results column...

Hi, been a while since last time... Right now I have a large amount of calculations that produce a range (results) of outcome on the spreadsheet (calc). A single input change all the outcome. I have a macro that loop through all the input (1...1000), copy results and then transpose and paste...

Hello, I have been looking for a formula and still get errors! If F2 <=110 = Short term OR IF F2 >111 OR F2<220 = Medium term OR IF F2>221= Long term I am looking for one formula with the 3 possibles results. Thank you in advance for your help! Zab

Hi all, I have the following LOOKUP formula =IF(C3&I3="","",IFERROR(LOOKUP(9.99999999999999E+307,1/(($FL$3:$FL$10002=C3)*($FM$3:$FM$10002=I3)),$FO$3:$FO$10002),"Backorder")) This seems to work most of the time but for some reason results "" when there is nothing found in FO3:FO10002 Sometimes...

Mind blank. I have two workbooks. Workbook 1 is the reporting workbook, has 2 sheets in it. Sheet1 is called Data, sheet2 is Count by Member (where I have all the graphs and results set out. Workbook 2 gets labelled with the date that it was created on. This workbook is where...

I have been working on a project with thousands of rows of multiple choice questions. I was basically creating an answer key by identifying which choice was in red font/text. However when I ran a macro to work through all of the rows outputting the font color values into some temporary columns...

Hello, I have a tricky, well, I think it is tricky formula I need to write. The idea is that any item that starts with "A" and number after "B" and numbers after "C" and numbers after "E" and numbers after or finally "K" and numbers after I would like the letter returned. Everything whatever...

Hello, I am trying to get records placed into two different columns depending on each grouping of ranges on dn1 and Ext in table example below: If dn1/ext is asingle range then needs to be separated with a comma ',", else is in subsequent ranges then separation with a dash "-" Results would...

Hi All, This works fine to retrieve the results from a MsgBox function and return the results to the sub that initiated the call, but would love to know how to pass the MsgBox answer from a normal sub back to the other sub. Sub MsgboxYes() If MsgBox_Ans = vbYes Then MsgBox "You Seleted...

https://imgur.com/r5isISk hi everyone the link there takes you to a screenshot of a spreadsheet I have operated for several years to record results of a weekly indoor football game with friends with teams chosen at random. hopefully its reasonably self explanatory how I have set it up as it is...

I have a vlookup set up so the drop down box is a list, all the results are in alphabetical order but the list is currently 1500 and growing, it takes to long to scroll down, am I able to set it up so if I touch H on the keyboard it will take me to the results beginning with H?

I am trying to help a friend and I am confused by the results. In a separate column called "Avatar", they want to identify the role of each individual based on their title. For instance, if the title has the word SALES in it, they want the avatar to be SALES, if the title has the word MARKETING...

Hi from York UK... This formula: =MID([@URL],SEARCH("/",[@URL],8),SEARCH("-t*.html",[@URL])-SEARCH("/",[@URL],8)) does exactly what i want but i just copied it off the internet. The results of the formula are below...

Hi can anyone help? I have some Data in Range("A5:H5") and a named Range("A5:H11") I get new set of results in Range ("A3:H3") after filtering some Data and then transpose the results into the first column of my named Range ("A5:A11") using the following code Range("A5").Resize(7, 1).Value =...

Hello all, I have very little experience with macros/VBA, and I need some help with extracting specific text from a large .txt file into excel. (I know similar things have been asked before but I have not been able to find code that I could use for my purpose.) The "txt" file I have contains...

I need to present to others a proposal on investing in some equities and bond funds and discovered that different functions return different results using the same parameters. FV, XIRR, and IRR, and the differences are not small. Here's a test spreadsheet I made that demonstrates the problem...

I have a tbale similar to below and i need get results which show how many non blank values in col2 for each unqiue value in col 1 <tbody> col 1 Col2 1 1 2 a 2 b 2 c 3 3 4 a </tbody> The results i would like are: <tbody> 1 0 2 3 3 0 4 1 </tbody> Does anyone...