Get instant live expert help with Excel or Google Sheets

I have an excel with 50,000 to 60.000 rows. It has a column data till column O. Column A has company names like "Abc limited","Abc Bpo","cde limited","cde bpo" etc.. Like this I have data for 10 companies. I want to filter the rows based on " Abc" , "cde" and dump data into new excels like "Abc limited","Abc bpo" in Abc.xlsx and "cde limited","cde bpo" in cde.xlsx Could you please help me with the solution that takes the shortest amount of time to perform this operation . Note : I am using Excel 2010. I tried using filter option but it takes too long time to work for aorund 60,000 records. Please help here.

I spoke recently with someone named expert 12 who was going to bring in a VBA expert to help. Here is a sample of the spreadsheet. What I need this to do is tell excel that when a number is identical in the C column to go to the S column, find the number in S for that duplicate group of C and make all the numbers in S for the duplicate group of C the same as the number found in S. you can see that C3, C4, and C5 have the same number so S3, S4, and S5 are the same number. If you look at C46, C47, C48, C49, C50 and C51 then look at the S column for the same rows I would need it to put the number found in S48 and S49 into S46, S47, S50 and S51. I would then need to find the next duplicate group of C and do the same thing. Finally Column T needs to repeat the same process as S. A mess I know

I went into Excel this morning to enter some data I was working on the final column to see if it would match my bank and all the sudden things went haywire. Instead of dates It showed code numbers instead of my deductions and my projected balances it showed formula's. I am New to windows 10 and Excel and I don't know how to fix it save making a new spreadsheet and starting from scratch. Please help me so I don't have to spend HOURS re-entering data all over again.

I am designing a system that will essentially return values for scanned bar codes. In that, one would scan the bar code, and the serial number in the A column of Excel would be generated. Scanning another bar code would generate the serial number in the spot below the first number in the A column and so forth. To know what product name to return, the formula is meant to read the prefix (since the numbers following the prefixes will always change) and then return the product name if the serial number contains the prefix. *See attachment and the formulas within for further visual aid* The "#" is meant to symbolize a number, so that in the second part of the formula (currently where the "?" is) the system will read "B123" only as a "B", and not a "BB" or a "BG" etc. (because the only place where "B" is the first character and a number is the second character is in the instance of "B123" or "B2345" and so on). (After looking at the sheet, the following may help with understanding of the issue) I was hoping to have the "?" in the 2nd character slot of the second part of the formula look for only a number, which would theoretically only return CEREAL, since the only place where "B" is in slot 1 and a number is in spot 2, would be in serial numbers like "B123", because "BB" would fail the second part of the AND formula (where slot 2 needs to be a number); and an instance like "C123" would fail the first part, because while the second slot is a number, the first is not a "B". MY SOLUTION was based on the hope that there is a symbol that can designate "any letter" or "any number". The trouble I had with the wildcard is that the "?" responds to any character, be it number AND letter. If for example "@" hypothetically symbolized any letter, then I would just put a "NOT(" in front of the second part of the equation, so that it would read something like "If the first character is B, AND the second character is NOT a letter (symbolized via the @), then return CEREAL". Or if the "#" symbolized any number, then it could be "If the first character is B, AND the second character is ANY NUMBER (due to the #), then return CEREAL". How do you represent "any letter" in excel???

i have a project in Ghana and i am in the US i fund the projects with US dollars at a certain rate, since the projects is in different phases i send money at a rate and i report on the funds as at the day of usage and the pertaining rate. i want an excel that will show the rate sent and the usage days rate so i can report on the marginal change in rates in both countries. for instance if i send $1000 today to ghana at $1 TO 4.26 GHS. the local currency today will be 4260 GHS for the $1000 i sent. if the people will use 600 ghs tomorrow and the rate will be 4.24 i need a formula that will show the marginal change in the rate report. so that I will know how much the original amount will be distributed on the project. whiles i will still be sending my periodic $ 1000 at prevailing rates which flactuates.. can you help?

I have an excel sheet instead of students names, it has ID numbers. The corresponding name that goes with the ID number, has been exported from a database onto another excel sheet. I want to create a formula that I can use on the exported sheet that will allow me to use it to reference the first sheet that does not have the students name on it and create a column that contains the student's name next to their ID number. In addition to the name, I will be exporting the grade the child is in. which would be helpful info to have next to the name. I am doing state reporting and need to correct the errors before the school can be certified for the following year.. Can you help me?

Hiya, I have 200+ worksheets in an excel document. Each sheet has a picture associated with it (numbered 001-200) saved in the same directory. The photo number is in cell A1. I want a macro which will pull the photo (based on the photo name in cell A1 ) from the directory and paste it into cell B2. Please can you help? Thank you

Hello! I will have a spreadsheet with 200+ worksheets. Each worksheet will have a photo associated with it. The photo name is in cell A1. I want the photo to be inserted into cell B1. All photos will be saved in the same folder (excel spreadsheet is in a different folder). Please can you help with a macro to automatically insert a picture based on the name in cell A1 for each worksheet? Thank you :)

I am having trouble finding missing values in excel. Please help! can I screen share?

I need help to find missing values in excel. Please help!