missing

  1. E

    Converting column data to rows urgent

    Hi Team. I need a VBA code to transpose.column data into rows. Below is example. Sheet 2 Column A Column B Sl no. Data 17957 Missing number 17957 Missing Data 17957 Additional data required 17957 Address not...
  2. Dazzawm

    Code To List Numbers Missing From Sequence

    I have a very long list of numbers in column A and I would like a code to tell me which numbers are missing from the sequence. Below is an example. Excel 2010 <colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5""...
  3. E

    Lookup returning blank on numeric criteria

    Hi all, I have the following formula which works fine for alpha numeric criteria but does not return anything on numeric criteria only? Could there be a reason I am missing here ...
  4. A

    Listview Control Missing

    I wish to give a workbook to members of our group. It contains a listview control, but it appears that control is Missing (even though it was in the xlsm file I gave them). I thought adding a Reference would fix this, but it appears not. Is there a solution for this? Thanks,
  5. J

    Filling missing IDs in column

    Hi, can anyone help me with this? I have in column IDs they look like this: A0002 A0010 A0003 Not sorted in any way and some of them are missing. I need to find the blank cells and fill it with what's missing. It has to be done using vba. Thanks.
  6. C

    Max & If Array for Dates

    I'm scratching my head with this conundrum I have two similar reports that mine the same data which lists transactions. In my first report I have a column which shows the date of the last invoice raised to a customer: {=max(if(Retailer=A1,InvDate,"None"))} In my first report, if there...
  7. C

    If value in table X not in table Y then return it - how to?

    Hi, I have one table (1) in sheet 1 and another table (2) in sheet 2. I want a formula in sheet 3 that checks if values in table 2 exists in table 1, if no, then the formula should return the missing value. Any suggestions?
  8. C

    Macro using Vlookup formula

    Hi, I'm fairly new to macros and am struggling writing one despite spending hours searching google for the answers. I'm hoping someone here could help. Most of my spreasheet is already populated but a couple of cells I have to enter my own data into. The following vlookup formula fills in the...
  9. N

    VBA Fill missing information

    Hi, Searching for help to automatically fill missing information in column E where cells in column D match: <colgroup><col><col></colgroup><tbody> Control Number Control 50071879 50071879 50071879 50071879 Critical Spares for Girth Gear 50071879 50071879 50071879...
  10. W

    Special cells blanks and "0"'s

    I have several sheets that have cells with no entry and sometimes they a null or blank or ")" etc. They mess with my formulas. So I though this would make them all the same, but it wont run. Any help is appreciated. What am I missing? FYI - it is formulated as a table - is that why it errors...
  11. H

    Apply Missing number Based on another Cell Value

    in cell B1 I have the following code: =SMALL(IF(COUNTIF($A$1:$A$153,ROW($1:$153))=0,ROW($1:$153),""),ROW(A1)) and Pressed CTRL + SHIFT + ENTER Where it finds the missing number in column A1:A153 However, I would like it to Display that value in B1 in C1 only if Sheet2!C(# thats missing) =...
  12. D

    Power Query 2016 - Missing Options - Merge dropdown - Joins

    Hi Everyone, I am using Microsoft Office Professional Plus 2016 and Inoticed I am missing some features inside of Power Query. I came across some ofthe missing features while attempting to merge two tables. The merge button inthe queries button does not have the drop down feature to allow the...
  13. M

    Novice Needs Help: Broken Formula

    Hello All, Novice Here I am trying to use a formula that will assign a value based on the words it finds in the table. I am not sure what I am missing. I want the resulting value 1-5 to appear in the "Raw" column. The table below is the mock up of what I am looking to do. =IF([@Answer]=""...
  14. I

    How to insert "0" where alphabet letters are missing.

    Hi everyone !! I have been working on a macro to evaluate the contents of multiple cells in a spreadsheet and fill in the missing letters of the alphabet with "0". In short, I need to complete the contents of the cell to show 7 characters which will be either seven "0", the letters A to G, or a...
  15. B

    IF function

    i want to copy all items on F column to G column without blank. i tried using "if" function but i think im missing something. pls help me
  16. P

    List Missing Numbers Without duplicates and blank cells

    Hello I need some help with a problem that I am trying to solve. I hope someone can help me. I have a list of values in one column (A:A), that can have blank cells in the middle of the range and also repeat values, and I need to compare them with a second list of values of another column...
  17. G

    missing project

    In a excel workbook I had written a long VBA project consisting of many forms (with their code) and various modules of sub codes. All this matter was stored in PERSONAL.XLB file and a command was set in the ribbon for rapid process activation. I made many copies with different names and...
  18. K

    Formula to find missing dates for invoices.

    I have an invoice table with all the invoices for all the accounts. Each invoice belongs to an account. We log the Invoice Date for each invoice. Each account should have 1 invoice per month. I want to make another table where all the account numbers are listed, and the second column would be...
  19. T

    Vba to tell me what cell in range has the most letters

    Hi Everyone, I'm trying to makea grid area where every cell is the same size, I have 500 cells and keep finding when I resize some text in some cells is missing is there a macro I could run that would tell me which cell has the longest amount of text? Thanks Tony
  20. K

    Search for missing characters

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> In the cells C6:F19 each row is filled by 3 characters 1, X or by 2, I need a formula, which can search each row and give a missing character result in the column H Note: if non of 1, X and 2 is missing I want it return "Nothing"</SPAN></SPAN>...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top