small

I have a macro that searches one of my sheets in excel, let's call the sheet "Keywords". After searching it returns the matches. The Keywords sheet has a bunch of terms like "dog", "small", "big dog", "small white dog", etc. The problem I am having, and wondering if there is a way to teach...

I'm sorry that I'm posting this in a rush so this may not be the best way to illustrate my problem - but here's an idea of what I want and how I'm getting it now: <tbody> A B C D E F G H I J 1 Fund Value Large Stock Mid Stock Small Stock Intl Stock ST Bonds Mid Bonds LT...

Hi, I have been puzzling over an Index match and formula for a few weeks now and was hoping someone could give me a nudge in the right direction. I created the below formula which works on one spreadsheet (a). When I try to extend the formula to look at 2 columns (different value in each) I...

I have a worksheet that contains data setup similar to the data below. Basically im trying to recognise rows that are not distinct based on the values in 2 columns. So row 2 , column e has the formula: =IF(COUNTIFS(A:A,A2,C:C,C2)>1,"Duplicate","") and so on for the remaining rows. rows 8...

Hello, I hope you are all well, Problem: I have this table (for example): I want to fill above source data into small forms / pattern / tables like this picture below, so I can be able to print them like that, What would be the solution, as I tried auto fill and it did not help? Thanks

Hello, appreciate if somebody can help to resolve this issue it's too much annoying. I have install office 365 2016 and excel is not showing the formula tip small bar like if you edit cell and type =if( then I should see small tip if true or false help its not coming in.

Hello. I have the following array: {2;FALSE;5;FALSE;FALSE;6} - row numbers Is it possible to get the values from the range A1:A6 based on the array above and get this result => {A2;FALSE;A5;FALSE;FALSE;A6} ? I can not use SMALL function since I need the values from A1:A6 to remain in an...

hi all i have 6000 rows grouped and sumarized. my question is: i need a total of Total: if i sumarize by sample: =SUM(A1:A6000) it duplicate the sum understand me? i add a imagen.... with small sample.... here my small sample: https://imgur.com/J0ixymC Thanks

Is there a way to use the SMALL function, so it works as if it were SMALLIFS? Specifically, both SUMIFS and COUNTIFS allow for dynamic range construction for the SUM calculation and COUNT calculation. I want to do the same thing with the SMALL function; how would I do this? I have listed some...

Hi, I'm trying to make this formula compatible with Excel 2007, I think I just need to replace AGGREGATE with SMALL but I'm getting errors. The INDIRECTS are referring to Data Validation cells where I have user-selectable filter criteria. Here is the original formula that works in modern...

Hi Guys, I'm trying to change the value on row C based on Row D sequencing.... Example. <tbody> Sold to C1 Business person D1 Plastic Company Index c2 Plastic Company d2 Small Plastic Company c3 Plastic Company d3 Small window firm c4 Plastic Company d4 Small bathroom fitter...

Dear All, In my Col A, I have fixed words, which I want to make them in small letters only. words are, Col A contains statements, any statements wherein, the above words are there...and they should remain in small letter... Pls share the code...

I have a few drawings that I print from within Excel and the text associated with those drawings was so large it was causing issues on a user's PC. We ended up tracing it to the fact that he had the Windows resolution magnifier in Windows 7 set at Medium (125%) which is the default. All of the...

I am trying to make a spread sheet of data for the nba arranging players against who they would be matched up against for that night's game. I currently have it set up so that the teams are labeled and depth position is input manually along with opponent. For instance, LeBron James (small...

Hi I got list in one table which contains three columns (Customer, Product and Type). On the other sheet I got drop down list. I am looking for a macro through which each row data populate in drop down list one by one. Like S.No.1 will populate in dropdown list then S.No. 2 will populate...

The actual data is below: <tbody> S. No First Name Last Name Gen ID Band Start Date End Date 1 Aaron Small 33371 S1 20-01-2017 14-12-2017 2 Abdul Karenina 33372 S2 25-10-2017 28-11-2017 3 Abe Sarandon 33373 S3 18-05-2017 20-07-2017 4 Abraham D'Arby 33375 S5 15-03-2017 20-05-2017 5...

Hi, I am trying to build a database with a search master page. My data is in separate sheets by country/Region, however they all have the same column headers. On my search page, I have a list of criteria I want to search by. Currrently I have managed to make it work for 1 criteria for 1...

I know how to use the SMALL function to determine the nth smallest figure; however, when you have a table like this, how do I determine the 3rd smallest figure from the GROUP? For example, if I could $25,000 as a single group, $30,000 as another group, and so forth. In this case, $35,000 would...