Excel messes my data up
I am trying to run vlookup for about 5K cells from range of 20k cells.
Now the problem is that some of the cells include only numbers and some
both numbers and letters, like AB11002.
I also have empty spaces on the data so I have to run trim on both data
before running vlookup. Just after trimming both data vlookup runs
correctly, but if I "touch" any cell containing only numbers excel
propably converts it to number and at this point excel don't think
those two cells that before was equal are equal any more.
So how in the earth I could convert my mixed data in the format e...volume control button/icon
How do I place this icon on my quick launch, or better on the bottom right
part of my task bar, for easy access?
The speakers I use on my desktop do not have the knobs to turn up or down
the volume, so having it always showing in my taskbar is necessary. Thanks
On Sun, 24 Jan 2010 09:44:44 -0700, "Cynanthis" <email@example.com>
> How do I place this icon on my quick launch, or better on the bottom right
> part of my task bar, for easy access?
> The speakers I use on my desktop do not have the knobs to turn up or down
>...Export Data in Excel
another Problem our customer have, is to export data in Excel.
All the time, they want to export more the 10,000 objects o excel, the get
only the first 10,000 and the others missing.
Have someone a idea why the can't export more the 10,000 contacts or
OK, I reslove it with the SDK.
I have create the "maxrecordsforexporttoexcel" in
"Andre Grumbach" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Hi again,
> anoth...Finding unique items in data field for pivot tables
I have a huge pivot table I'm trying to create and for a critical item
I select I get the following message:
A field in your data source has more unique items that can be used in a
PivotTable. Microsoft Excel may not be able to create a PivotTable or
may create the PivotTable without the data from this field.
Any ideas how I can find the duplicates and create the PivotTable with
Based on the message, 'duplicates' is not your problem, *Unique* items is.
Pivot tables are limited to 32,500 unique items per field. So if you're
analyzing product sales, for...import and saving data
I import a file and it is formatted n text but t text group has a
number of values that want in separate cells. Iam lost on how
to do that. Another issue is how do i save a spreadskeet in
comma or text format.
Import file format, e.g.,
123 ws 345 154 (all n a single cell) but what I want to do is
format the data were each group of numbers or letters are in a
iF I receive the above as 123,ws,345,154 how can I mport data nto
With your data in column A, select the entire column, goto Data >
TextToColumns > Delemited > Delemit...how to summarize and chart raw data
I am needing some help with how best to summarize and chart some raw data. I
extracted from an application we use that tracks appointments and dumped it
into excel. The columns I am interested in are:
Each name is associated with 4-5 appointments for one date.
I am trying to see how much time is between appointments
An example of the data:
12/01/2004 Smith appt_start appt_end
12/01/2004 Smith appt_start appt_end
12/01/2004 Jones appt_start appt_end
12/01/2004 Jones appt_start appt_end
and so on. The...Sorting data and searching
I have an Excel Spreadsheet in which one sheet that I created four columns
that contains the following:
Table Name, Tabel Description, Table Information, Table Type
Once I have enterred the table information, I highlighted the range of
information that I enterred and right-click and chose sort A-Z.
Everytime that I do this it is sorted by Table Name.
Here are my questions:
-How can I be sure that when I enter a new row that the information would be
sorted by the table name and How do I automate this (Can it be done in a
-How can I search for a table name?...How to keep updated table of data ?
I have two sheets containing table with many fields with data.
I want to keep one table by updating it according to values in th
Please help me finding good way to do so.
Daniel761's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2587
View this thread: http://www.excelforum.com/showthread.php?threadid=39249
...Series Source Data
I have plotted one series:
I would like to replace the red bold 3 with
INDIRECT(ADDRESS(2;7);1) so that I can put the number 3 in cell G2
How/Is this possible ?
Message posted from http://www.ExcelForum.com/
Hi; I am looking for a way to select an entire sheet then delete only the
data from it, leaving all formulas and formats intact. Any help will be
See answer in microsoft.public.excel
No need to post to multiple groups
Microsoft MVP - Excel
"Joel" <email@example.com> wrote in message
> Hi; I am looking for a way to select an entire sheet then delete only the
> data from it, leavin...Is there a free toolbar button library available anywhere
I am looking for a cataloged of typically 15x16 images for use on
Does a free public collection of these exist?
http://www.glyfx.com/ has free icon set for basic commands. There are quite
a lot of free icons libraries in Inet, but none of them provide professional
looking icons for serious applications. If you are looking for various
'childish' (imho) icons, check these:
For business use, y...wrong email address sends
How do I make Outlook send the correct email address and
not a business account that I do not want going out with
I'm not sure if I understand your question correctly -- are you asking
how to force Outlook to send messages through one account rather than
another? If so, I need some more information from you before I can
answer: What version of Outlook are you using, and if 98 or 2000, what
mail support mode? If you're not sure, look at the second line of Help
| About Microsoft Outlook -- it should say "Internet Mail Only" or
"Corporate/Workgroup". ...Count group of data
Hope someone can help!
I'm looking for a formula to produce the following result from data
Data can be in text, colour or numeric format
8 4 2 3 1 11111111 1111 11 111 1
2 4 1 3 11 1111 1
2 1 3 1 2 11 1 111 1 11
That is a really confusing post. I for one have no idea what you are trying
to count, or the expected results. And what do you mean by ... can be in ...
<firstname.lastname@example.org...Emails shown with wrong date in overview-screen?
i have the following problem:
i have made a constellation of folders in witch i sort my incoming and
outgoing mail to.
now i have found the following phaenomenon:
in one of these folders i see a bunch of mail (sent by myself) witch all
seem to be sent on the same date, 15. december 2004.
but in reality this is the wrong date, they have been sent over a long
period reaching back even until 2001.
if i doubleklick on the mail and view it the correct date is shown.
only in the "overview-screen" where all the mails are listed, the date is
what can i do about ...Coloring Alternative Rows only if data is there
I have a spreadsheet with [ =MOD(ROW(),2)=1] conditional formatting
in it. I want to highlight this only if there data in there. I have
googled if but cannot find the method can anyone post the method or
provide me with link. It will be 2nd conditional formatting I think :l
"BetaDocuments" <email@example.com> wrote in message
> I have a spreadsheet with [ =MOD(ROW(),2)=1] conditiona...How to overwrite data in file?
I am using a text file to log progress of a long-running macro.
I want to continuously overwrite the first line with variable-length data.
The following paradigm demonstrates my problem:
Open myPath For Output Access Write As #fd
Print #fd, "1234567890123456789012345678901234567890"
Seek #fd, 1
Print #fd, "abcde"
I want the file to contain only "abcde". But the actual result is:
Apparently, "abcde" CRLF overwrote the data, but that did not cause the
end-of-file to be rewritten.
...Extract unique data
I am using excel 2003
I have a file like below
Rate month GBP
1.46 FEB 2000
1.47 MAR 3000
1.47 APR 3500
1.48 MAY 1000
I want to create summary
Rate FEB MAR APR MAY
1.47 3000 3500
I can use sumif function to return the total, however, how can I insert only
the unique rate in the first column automatically.
Thanks a lot !
I suppose information is in sheet 1 columns A,B...Command button on data-entry form
Is there a way to add a command button to a form that displays data for
reference? I'd like the user of the form I'm creating to choose a chemical
abbreviation from a dropdown but be able to click a button and display a
table containing the full chemical name and unit. Or else have a dropdown
with three columns? It's easy to do in Access, but I can't seem to figure out
how to do either of these things in Excel.)
It might be easiest to use a range of 2 columns (why 3???).
Then you can make your combobox have multiple columns--including both the
abbreviation and long name....What wrong with sumproduct function?
I would like to sum all numbers, which match following conditions,
press ctrl + shift + enter
but it returns zero, and I have checked it, zero should not be the result.
Does anyone have any suggestions what wrong with sumproduct function?
Thanks in advance for any suggestions
1. Sumproduct is not an array function. Use Enter, not Ctrl-Shift-Enter.
2. You must convert false/trues to numbers. One way:
"E...Wrong Date/Wrong amount
In the Money 2004 check register it reports the last download date as
well as the balance in the top left corner. The only problem is that
it is totally wrong. It reports some bogus amount with a "downloaded"
date of 10/9/2003. It is quite stubborn as nothing seems to affect
Does anyone have any idea of how to correct this?
Harry Calahan wrote:
> *In the Money 2004 check register it reports the last download dat
> well as the balance in the top left corner. The only problem i
> it is totally wrong. It reports some bogus amount wi...Data validation behaviour
Local named ranges:
refers to: = Codes!$A$10
evaluates to: 46 (always a positive integer)
refers to: = Codes!$Z$12
refers to: =OFFSET(Codes!Short_Name_Header,1,0,Codes!Depth_Range,3)
refers to: =OFFSET(Codes!Short_Name_Header,1,0,Codes!Depth_Range,9)
Workbook-level named ranges:
refers to: =Codes!Sign_Table
refers to: =Codes!Table
In worksheet "Analysis", data validation on a cell is set to Custom formula:
This be...Disable MS Office Button & Navigation Pane
Is it possible to remove the 'New', 'Open' and 'Save As','Close Database'
and 'Access Options' options from the MS Office Button? I created a custom
Ribbon that strips everything out, but would like to get these options out
of the hands of the users.
Also, is it possible to hide the Navigation Bar as well?
My app very thoroughly handles user navigation, not to mention that I don't
want the users to have access to any of these options at all.
I screwed something up and need help big-time. Somehow the default
position of the cursor when I start a new document - or Outlook mail
message - is in the right center part of the page. In fact, if I even
open a document, it's formatted with everything scrunched over to the
right. I can backspace and get the cursor to the right and it's not a
big problem on documents with simple formatting, but for some complex
documents, simply backspacing makes the formatting even worse. HELP
For a start, see http://word.mvps.org/FAQs/AppErrors/BlankDo...Buttons in forms (in Outlook 2003) not doing anything?
So I was set as an approver on a form someone else filled out.
The link comes to me, and when the form opens, and I click on the
"Record Approval" button, nothing happens. It's like the button is
disabled, or there is no 'command' linked to it. (It has worked
A few things I have tried:
- Make sure the "Collaboration Data Objects" is installed in the Office
- No secondary monitor plugged in.
- Run "Detect and Repair".
- Clear Forms Cache
Any other ideas?
Where is the form published? Are the items using the form located in =
your o...What's going wrong in Outlook 2003?
When I installed the new Office 2003, I had no problems
with Outlook 2003. I received and send mails whenever I
want. A few days later, I get a message from outlook that
Outlook could not make a connection with the server of my
provider to get my mail on my computerb (I didn't change
any settings!). I checked all my settings and there are
good (I checked the mailserversettings, ports, etc) but
the result is still the same: Outlook cannot make a
connection with the mailserver. After that, I called my
provider to ask them what to do. They told me that I must
remove all the ...