-
Hi, I have a data like below ( all in single cell) but I want first line in seperate column and second line in seperate column.I tired using space but it didint worked, even i used above mentioned formula through delimiter. But it is not working. please can any one help me in resolving this. data as...
-
Right I've now got another problem with this. I have an index of numbers that I need to filter so that the correct information is brought up at the same time. The index contains numbers that go up sequentially like so; 0001, 0002, 0003, 0004 etc and from time to time I will need to filter my table...
-
Hi, I'm fairly new to all this VBA side of ecxel and have gotten to a sticking point. I have a table of information that has several colums of data as shown below. The actual list is a lot longer than this! Document Type Document Number Document Issue Customer Name Copy Type Date of Input Input By...
-
Hello all, I am very new to excel and I need help. Currently, I am writing a macro to populate results into a newly inserted column C (date and time) after I captured info from column A (dates) and column B (time) for a list of data that could easily go beyond thousands row of records. So far, I managed...
-
I currently have a formula (Below) that checks tolerances and determains if the number passes a criteria where V$2 is 0 and W$2 is 4. I would like to add an "If Blank" return True/Blank(havent decided yet) statement but cannot find a place to put it where it will work. =IF(OR((AND(V7*0.95<...
-
Hi. I need help with a type of counting problem. I have a huge excel data file with over 50,000 data entry points. It is forex data. I have a list of several banks. And their trade dates, and a bunch of other information columns that are cost, volume, what currency traded in, and more complicated diagnostic...
-
Hi, I am in need of expert help and as I was browsing the nest I came across this site, so I joined. Well I have created a work book which pulls out data from the schools database and populate separate worksheets. Now I have field titles such us 'Tutor Group', 'Gender', 'Ethnicity'...
-
My understanding of Excel is pretty basic so 1. forgive me if this isn't the right section and 2. I'm not exactly sure how to ask this question. I am a teacher and I have a grade sheet that has several projects' grading rubrics in columns A and B. Student names are then arranged in columns...
-
I have two workbooks on our network. One workbooks is our main one that we input data. The other workbook contains the summary. If I open the summary workbook I get #value in the field unless I open the other workbook then the field does the calculations. Can I open the summary workbook with out opening...
-
I'm new to the group today - My issue is a manager has used comments in excel 2007 for just that comments. Now the company is beginning to use Act for customer discussions and I want to export all his comments to import to a dbase. I can see that all comments in the print function have a cell reference...