Get instant live Excel expert help to learn how to use Small function in Excel

Good Morning, I have two small issues I am hoping you may be able to help me with. One is formula based the other is sheet based.

HI, I need to verify that a formula I was given is going to work correctly. I have a 200K row spreadsheet and the results are not producing what I expect. In a small file that was used to test the formula, it appears to work. The formula is =SUMPRODUCT(($A:$A=A2)*(B2>$B:$B))+1 I need to take value in A, compare it to value in B, and then in the next column, rank the items in B numerically. However, the values in column A and B frequently change. So there may be results 1, 2, 3 or 1,4,5,3,2 (I will need to sort to get the results in numeric order). I do know sumproduct is an extremely resource intensive formula.. Thank you.

I need to alter an array formula. the current formula searches for e=m when q>5. I also need it to search for e=m when q<-5 =IFERROR(INDEX('DR 1994'!$BL$1:$BL$1500,SMALL(IF(('DR 1994'!$E$1:$E$1500="M")*('DR 1994'!$Q$1:$Q$1500>5),ROW('DR 1994'!$Q$1:$Q$1500),FALSE),ROW(A7))),"")

When I format the fill of the Plot Area of my chart in Excel, I select Picture or texture fill and Insert picture from [File...]. When my file size is small, less than 1000 kb the image is crisp and at the same DPI as the image in the file. When the file size is large, Excel will reduce the DPI of the image and it begins to blur. The larger the file size the more blurry the image. Is there a way to prevent this from happening?

I need to make 2 calculating excel spreadsheet for my 2019 budget. Clinic as well as home care. The focus to be on census and moneys from each visit (for the clinic) and Services as well as census for the home care. Do you have people who can help me with this locally? I am not an excel expert and i do not recall how to make calculating spreadsheets as they are usually done by my company, however now I work for a very small company and they have no templates like this

I need to create a spreadsheet to track workers for jobs. I need the months to be scroll able but need 4 x 4 small cell boxes under each month to allocate for the the weeks. (needing 52 weeks per year)

Hi I have two small issues: Firstly I am unable to sort and filter my income and expenses by date or amount; Second on the expense sheet the expense and notes drop downs do not show. Can you help?

i need to know how to print the large excel sheet ..when i am trying to print it.it is going to turn into very small data even just dots how to solve it plz hepl

I need a formula to return one of 4 options depending on the value of the previous cell. So IF I2 <30 "Small" IF i2 > 30.0001 AND <60 "Medium" If I2 >60 "Large"

Prepare some form of a lookup that returns the names that appear on both lists. For each name prepare a lookup that returns the rank of the name on both the male and female lists.Hint: There are only 331 names that are common between males and females. Use a combination of the functions SMALL and LOOKUP and VLOOKUP.