Query not showing all phone numbers

huzzsh

New Member
Joined
May 6, 2019
Messages
1
Hello, I am using google sheets.

https://ibb.co/rdwFqx8

I am using the following function in cell F2 =query($A$2:$D$1000,"select * where D is not null",0)

As you can see in some orders the phone numbers are not showing (Such as order 1208 1209 1210 1215 1217)

I am not sure whats going. Sometimes when I add more orders the phone numbers suddenly appear, but then they disappear as more orders are added.
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Watch MrExcel Video

Forum statistics

Threads
1,100,141
Messages
5,472,753
Members
406,835
Latest member
steve43040

This Week's Hot Topics

Top