1. I

    Problem with Rank Formula

    I can't seem to figure out why the rank is skipping numbers. Here is my formula. Thanks in advance!! =RANK(E2,$E$2:$E$26,0)+COUNTIF($E$2:E2,E2)-1
  2. L

    Multiple Criteria Ranking without Skipping Numbers when there are Duplicates

    Hi, I am trying to rank a list of orders withing a container based on their shipment date. The difficulty is that within each container there can be multiople orders with the same shipment date. I can use SUMPRODUCT to rank multiple criteria and get the order within each container. The...
  3. S

    Cntrl + arrow to skip to next field with data is skipping fields with data?

    Hi, the shortcut Ctrl + arrow is skipping fields with data? I've tested both up and down columns and also left and right in rows. There is no pattern to the data it's skipping over. Has anyone ever had this occurrence? Philip
  4. J

    Excel is skipping blanks when pasting and I don't want it to.

    After the last update, excel 365 has been skipping blanks regardless of the checkbox in the paste special dialog. I can't seem to find anyone with this issue on the internet. So, I have resorted to seeking assistance here, in this forum. Additional info: This problem is a huge p.i.t.a. when...
  5. H

    Strange Problem - Step Into fine, Run fails

    Hi Everyone, I am getting the weirdest thing happen to me when I try and run a code. When I run it via "step into" and hold down F8, everything works perfectly. When I just hit run and it does it (way faster), it skips deleting out columns in my autofilter function. I've tried everything...
  6. J

    has any one experienced VBA skipping applications.

    windows XP office 2007 saving as 2003 xls. I have a Excel VBA which calls other excel spread sheets and run a VBA on opening. What started happening in the last couple of weeks is the spreadsheets will open but the macro does not start on ever other spreadsheet. I can change orders of...
  7. L

    Hiding/Showing every other column Macro Code

    Hi there, I have a spreadsheet where I want to hide/show empty columns. Problem is that I have everyother column hidden already. I wrote a code that works great, but when I run a macro that adds columns (hidden and showing), the new macro does not work. Can anyone help? This is the code I...
  8. R

    skipping cells

    Hi, I imagine this should be an easy one, but I'm a bit slow with these things. I want to sum blocks of five cells in the below format but not sure how i can reproduce that pattern down a column and then across columns. Tried Indirect with row function but that doesn't let me go across...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...