hit

I'm looking for a way to add whatever number I type in my active cell to the cell immediately adjacent to it to the right. However, the part that gets tricky.. Is that I only want this to work in a range of cells. . . not the entire sheet. I have a tally of numbers in the range N5:N24...

Right now I've set up the query to pull form a folder. However, I'd like to move the files to a different folder/location. So I went ahead and did that. Then I went into query editor and double clicked on "Source" under applied steps. I changed it to the new folder and hit "OK." I get this...

Can you use the range.find method to find the lowest row that the contents of a text box have expanded down to cover? For instance, if I have a regular text box with resize shape to fit text selected. I put the textbox in row 2, type "a" + hit enter, type "a" + hit enter, type "a" + hit enter...

Hi, =ANTALL.HVIS(Bruker0:Bruker150!E5;"1") Translated to english Excel: =COUNTIF(Bruker0:Bruker150!D13,"1") This doesnt work: On the shetts Bruker0, 1, 2.. I Got a value in the D13 that range between 0 to 5. I want it to sum up the numbers, in the case over, 1 and tell me how many 1 there...

I have a list of items ordered by a value representing years left and an value attached for each item. I need to determine if there is an easy method of choosing a range with an average age (say 15 Years in my example) and seeing what the average item value is for that group. At the moment I am...

Mr (or Ms) Excel Community, I need your help to figure out the formula as I hit the roadblock. I used the following formula to come up with the reporting liters value of the below table: =IF(AND(B4>=D2,B4<=E2),C2)*B3 The outcome I am trying to achieve that we manually input gallons value (B2)...

Ive a workbook with several sheets and alot of locked cells in each but i seem to have hit a limit! the later sheets will not Lock the cells!? really?

I have the following INDEX formula: =INDEX(Sheet2!$B$3:$Q$3,1,MATCH(Sheet1!A25,OFFSET(Sheet2!$A$3,MATCH(Sheet1!A28,Sheet2!$A$4:$A$13,0),1,1,16),1)) It should resolve to the following: =INDEX(Sheet2!$B$3:$Q$3,1,8) and give me the answer of 150%, but instead I am getting a zero. When I highlight...

Hi, Is it possible to calculate averages on a userform with TextBoxes/Comboboxes? Example: Combobox1.additem = "50%" combobox2.additem = "100%" Maybe...? Lol Textbox1.value = combobox1.average + combobox2.average Visually it would say within Textbox1 75% So, before I hit submit on the...

I have a list of order numbers in column A, in column B I have a list of corresponding %s (from a formula) I want to create a list of all the PO numbers that haven’t hit between 95 & 105 (for example, these would be in a cell so I could change them) basically a list of all the PO numbers that...

Hi - I am trying to create a formula to determine revenue share for a company I work with. The initial revenue share percentage is 5%. On a yearly basis, Company X will receive 5% of Company Y's revenue until a $12 million cumulative number is hit. Once $12 million is hit, the revenue share %...

I am having an issue with my form control scroll bar. It works just as intended unless a user is entering data in one of the cells. If a user enters data in cells R77:V94 and does not hit enter before hitting the scroll bar, the scroll bar jumps to the max value. Why is this? I can certainly...

hello- I have a button that saves the workbook (code below). Irregardless if I save the workbook using the button (which works), when I go to close the program, it still asks me if I want to save (excel generated, not me). How can I get it so I don't have to save twice. I'd like it so that if...

please !, separate last digit, create a field to type the strings then confront with which lottery hit 80% or more ojetivo = play the same string in several lotteries

Hi I often end up pasting in information from various sheets and want to change it all to Calibri, so I hit control+A twice and then type in the Font box. However, when I type in Calibri, it defaults to Calibri Light, which I don’t want. Even if I exactly type “Calibri”, if I hit enter, it...

The formula below resides in cell F3 and it works perfectly. If a "hit" is found in C2:C600 then the value in column C is displayed in F3 =IFERROR(LOOKUP(9.99999999999999E+307,SEARCH(A3,$C$2:$C$600),$C$2:$C$600),"") I am trying to figure out a way of it displaying the value from column B...

Hi all, Using Excel 2007 I have Googled and Googled and tried to use various examples to help me with this but to no avail. I know nesting isn't ideal, but I need to possibly nest around 10 statements. However I have hit the limit of 7 and can no longer add any more conditions. Below is an...

Hey guys, hopefully someone can help before I get back into work tomorrow... I have a list of ~10 customers, each of which have a target revenue. For all 10 customers I have sales data going from 2013 to date (by month), along with month-to-date sales data for each month. I need to calculate...

Hello all, I have a four column table (columns A through D) and I have four "data entry" cells (F2, G2, H2, and I2). What I want to do is this: enter my data in F2 through I2 hit enter (or whatever button excel needs me to hit) have those values copied into the next available row in the table...

<style><!--table {mso-displayed-decimal-separator:"\,"; mso-displayed-thousand-separator:" ";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}tr {mso-height-source:auto;}col {mso-width-source:auto;}br {mso-data-placement:same-cell;}td {padding-top:1px...