Archive for the 'excel' Category

Example Cell A1 contains “1234 Main Street West” What formula returns everything before Street including Street. The amount of characters before and after street will vary but street is constant.

Example Cell A1 contains “1234 Main Street West” What formula returns everything before Street including Street. The amount of characters before and after street will vary but street is constant.

I’ve created a macro in excel to sort rows by date. Here is the formula: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, [A10:A5000]) Is Nothing Then [A10:F5000].Sort [A10] End If End Sub I don’t know how to make it so that it only sorts the row until something has been entered in the [...]

I have two columns, A and B. In the first column I will be inputting numbers. In the second column I have a simple formula to have it add each row entry to the previous number (as I enter numbers into A2, A3 and so on, column B will show that addition – so, if [...]

I mean, I feel really stereotyped when people tell me that I am an Asian and it’s why I take accelerated classes and ace them… Why is this? I think that everyone, no matter what race or background group has the potential to excel. Also, for anyone who might think me wrong, my parents wouldn’t [...]

Okay, all I am doing is copy-pasting all of my needed files into cds and now I want to clean up my disk and start over. But how exactly do I do this ? Is there a special program which shows me all the files I can delete from my pc ? Also, I don’t [...]

Guys, next week I have interview with some companies for Data Analyst profile. The profile requires extensive knowledge of Excel, Access and VBA. Can you please suggest me some questions and answers as well. I’m really nervous. Thanks in advance.

Friends, is there any option so that we can have Excel 2003 style menu in Excel 2007. I think it is possible, I read it somewhere on the internet few months back but can’t recall the site. Please help.

I require the use of pivot tables in excel. In earlier version of excel like 2003/XP, I can do it easily but now in Excel 2010 installed by office peoples, I found it really difficult to use them. The new Excel interface is very different. Please guide me some good resources or tell here that [...]

to create dynamic named ranges.