missing

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...

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""...

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 ...

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,

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.

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...

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?

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...

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...

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...

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) =...

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...

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]=""...

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...

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

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...

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...

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...

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

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>...