small

I tried to do a 1,000,000 record pull which took quite a while. when the process finished I got this error: expression.error: evaluation resulted in a stack overflow and cannot continue. However, when I do small batches the data comes over fine. Is there a way to get around this error? Much...

I'm trying to compose a formula for if X exists in $A4 and Y does not exist in $A4 then insert Y Please see sample spreadsheet snippet below. The closest I've come is =IF(ISNUMBER(SEARCH(B$2,$A4)),B$3,"") which only checks if X exists then inserts Y. Having trouble with the "does not exist"...

Hello, I keep entering 4-11-9 and excel turns it into date format. I don't want this to be a date because it is a part number for something I'm working on. I tried changing the format to 'text' but then it has a small small triangle in the corner and a note in the cell that says "This cell...

Hi everyone. I have a worksheet that has multiple pages that users can input information into. The information entered is then automatically updated in a cell on the first page. I'm currently doing that for the first two sheets and it works. However, when I add the code for a third sheet I still...

Hello, I would like to know if there is anyway to "lock" a cell if the previous cell isnt filled. In other words, I have to fill a file with multiple cells. If I accidently forget to fill one cell and pass it up, I want Excel/VBA to tell me that I have forgot to fill a cell. I have a small idea...

Hello, i have modified a couple of formulas I found, but am struggling to make them dynamic enough without having to edit the formula when copy pasting. All of this data below is reading from another sheet based on "JOB DESCRIPTION 1" field. Is there a way I can modify this formula below, to...

Hey everyone. I have a pretty simple spreadsheet downloaded from an Access database. It has 7 columns of data (small numbers or strings) and about 1000 rows. There are no special formulas, characters, characters, or conditional formatting. It is just numbers and/or text. The file size is 812...

Hi, I have this formula that work very well but I need some help when the formula return a 0 that the 0 will be at the end ( on the right ) and not at the beginning, thank you...

I would like to insure that when ever a workbook is opened it would automatically: Sort all the entire workbook small to large in Colum a, retaining the headers? Thanks -Eds

HI, I have seen there are ways to return the smallest value with certain criteria using the SMALL(if(Criteria Array: Criteria Array=Criteria, Value Range:Value Range),1). I want to know if there is a way to identify the Smallest value and return a value in another column based on criteria...

Hello all, I hope someone can help me with the following issue: I have 2 tabs in Excel: 1. Product Line Attributes 2. Data Sheet In tab 1 (Product Line Attributes) I have a list of product lines (1 column for the product line ID's and 1 for the product line names) with the attributes that...

Hello, I am a new in vba and now I want to search for duplicates in column a of all work sheets, sum the total working hours including duplicate date in column d and show sum value in other excel. Can Someone help to me and now I found someone posted the following code on this board it was...

Hello, In Excel/VBA, I have variables: Q and R. They are both a function of x (complicated formula - but no need to describe it here). D = Q^3 + R^2 So I have: x in column A Q in column B R in column C D in column D At one point, Q^3 so small that D = R^2. I am adding a small number (Q^3)...

Greetings, guys. May I impose to ask for help on a personal project, please? I've got a small 5x7 grid of cells in a spreadsheet that I use to edit fonts for an OLED display. Basically, I put a null or a 1 value in each cell (the cell color changes to black for a 1) and I use the resulting...

Hi, I need help to make conditional formatting formula vba code, PFA excel file Main file and output file download file from http://pikkaa.com/excel/ I have one column (brand) and one is (Small image column) I have data in two cell seprated by | need copy that in saprate rows while...

Are we allowed to hire someone for a small project? The details are too much to post for help in smaller segments, so I'd rather explain them one-on-one and work on the project together. If this is allowed here, please reach out to me ASAP, I need this done by Tuesday. Penny

I was using the small function until I got stuck. Is there a way I can match the name to a value when there are duplicates? For example, in the chart below, I would like to order these from smallest to largest and then bring in the name next to it also. Since I have two names with $1 how do I...

Calculate a cell with set of rulesI want a formula to calculate K8 with these set of rules: If C8 is 0 to 25 than K8 = "Very small" If C8 is 26 to 35 than K8 = "Small" If C8 is 36 to 45 than K8 = "Large" If C8 is greater than 45 than K8 = "Very Large"

I want a formula to calculate K8 with these set of rules: If C8 is 0 to 25 than K8 = "Very small" If C8 is 26 to 35 than K8 = "Small" If C8 is 36 to 45 than K8 = "Large" If C8 is greater than 45 than K8 = "Very Large"

I'm struggling with what I think should be a simple function. Hoping someone can help. I want to use a Sumif focusing on the name. i.e. =SUMIF(B2:B29,"Brett",H2:H29). This equals 57.2 But I only want to smallest 3 numbers. i.e. =SUM(SMALL(H2:H29,{1,2,3})). This equals 1.64 So I thought I...