Search the Community

I have a sheet with over 2000 rows. The contents of column B and C should both be in column B, so we need to merge the C with B. So I only want to merge cells horizontally. How do I do this in Microsoft Excel or Google Sheets?

I have sold and bought cells. I have to subtract sold from purchased to know what the profit is. There are several dozen transactions, so adding them manually will take a long time, and besides, there may be an error while adding them manually. How to make Excel automatically add sold and purchased cells? And then subtract the purchased from the sold? I tried to do it somehow, you can see in the video but it doesn't add everything. 2023-10-02 12-06-01.mp4

So I was looking on the internet how to do it and it was that there was a space before the SUM function or that the cells must be formatted as general or I also did numbers and it doesn't work. Does anyone know what's going on? And how to make the numbers from the BUY Excel add up automatically and how to make the same from the SELL cell, because when manually selecting something can be missed.

Hi Team, I am trying to create an excel file which is hosted on sharepoint which does the following purpose: 1. It maintains records of each file and folder of a sharepoint document library (has links to access every file/folder) 2. If any changes are done in the document library, the excel file should synchronize automatically with this updated change. I am trying to achieve this with power automate but I am finding it very hard to do so since I am quite new to this. Can some experts please guide me on how should I approach this? I have found resources to do this with document lists but nothing for document library and excel. Thanks.

This is turning like this when i type its barcode number pls help VID-20230515-WA0055.mp4

Hi, I have a requirement of just installing excel 2016 64 bit. So far I have only been bumping into Office suites which offers no option to select only Excel and installs all office packages in it. In these installations theres no option to uninstall unwanted packages individually as well. so if anyone know please do give me some lead. Thanks.

Help me please, I have it now for evaluation. How to do it in exel? excel 3.xlsx

Desperately need a decent Free software to convert pdf's of bank statement into a workable excel file so data can be manipulated as needed for accounting work.

Hello, We use Office 2016 standard at my job, a couple users in Germany office aren’t able to view or get the right calculations when they change a number in the cells inside excel billing sheets.( more than 1 excel files that includes billing calculations) a user from our US office sends the germany office the excel files which get edited by them and which then get sent back after. So one user in Germany makes all the edits and send it back without bay issues. There are 8 users at the office and only 1 person is able to make edits to these excel billing files (changing numbers in calculations). This 1 person computer is German language OS while the rest are in English. Everyone is using Office 2016 standard. I don’t know if the error is being caused by the decimal and point system that is different in the U.S. and Germany. I have tried the following: installing the Germany language pack for office2016 (tried 2013 as well/does not work) office windows updates are all up to date, computers are all windows on 20H2 (did not work 1809/1909 either), tried putting in the password to unlock the billing sheet (calculations did not give correct results), any suggestions on how to resolve this?

Hello, I have an excel sheet with duplicate phone numbers in a specific column. I want to keep the first number and delete the rest of it's duplicates without deleting it's rows or shifting up any of the cells. Any guidance to create a formula or some other method if any would be very helpful. Thanks.

Bit of a strange one... we have about 1500 users in our AD. We’ve had 200+ reports of people receiving the error message “Excel couldn’t start last time. Safe mode could help you troubleshoot the problem, but some features might not be available in this mode. Do you want to start in safe mode?” Most people press no and carry on as they were. The message will disappear for a random amount of time, might come back the next time you launch excel, maybe the next week, maybe the next month, seems random. So, my first thought was was a rogue add-in, but here’s the kicker - some people who reported it don’t have any add ins what so ever. Some people have a few, but none seem linked with people having different add-ins all having issues. Due to the fact that the message pops up sporadically it’s proving hard to troubleshoot. It pops up both when trying to access a document (multiple different ones, but not every time) & also when launching the Excel app on it’s own, so it doesn’t seem linked to a specific file. Users are on various version of Windows 10 from 1809 - 20H2. Most are using the latest version of 32-bit Office with it set to auto update. I’m personally having the issue with office version 2103 build 13901.20400 on W10 20H2. I’ve done some Googling and I can’t find much info from any other organisations so I’m struggling to believe it’s a Windows or Office update. Any ideas? It’s stumping our 9 strong IT team. I may have missed something so any questions feel free to ask. Thanks a lot!

Hi, I am trying to create a sequence of numbers in a column like this. 64 0's, 64 1's, 64 2's and so on. I have tried using SEQUENCE(D11*E11,,0) but it only counts up every cell. Is it possible to have it repeat 0 64 times, then repeat 1 64 times and so on?

Hi, I'm looking to be able to resize a table and then fill the table cells with data from another table in a custom order. This is how I resize the table Sub Resize_Table() Dim rng As Range Dim tbl As ListObject Set rng = Range("DisplayTable[#All]").Resize(Range("E11") + 4, Range("D11") + 1) ActiveSheet.ListObjects("DisplayTable").Resize rng End Sub Is there a way to fill the cells with data from another table?

Budget (including currency): $1,200 USD Country: United States Games, programs or workloads that it will be used for: Gaming (not heavy), MS Excel, content creation Other details : PcPart Picker List as shown below. All parts ordered from Amazon USA. Please review this new desktop computer build. I already have other peripherals such as monitor, keyboard, and printer. I will be starting up a new content creation, most likely on YouTube and will be purchasing a few accessories such as a light ring, a few tripods and a GoPro cam. PCPartPicker Part List CPU: Intel Core i5-12600KF 3.7 GHz 10-Core Processor ($259.99 @ Amazon) CPU Cooler: EVGA CLC 360 74.82 CFM Liquid CPU Cooler ($122.18 @ Amazon) Motherboard: Gigabyte Z690 UD AX DDR4 ATX LGA1700 Motherboard ($199.99 @ Amazon) Memory: TEAMGROUP T-Force Dark Za 16 GB (2 x 8 GB) DDR4-3600 CL18 Memory ($54.99 @ Amazon) Storage: Samsung 980 1 TB M.2-2280 NVME Solid State Drive ($99.99 @ Amazon) Video Card: EVGA GeForce RTX 3050 8GB 8 GB XC GAMING Video Card ($329.99 @ Amazon) Case: Corsair 4000D Airflow ATX Mid Tower Case ($104.99 @ Amazon) Total: $1172.12 Prices include shipping, taxes, and discounts when available Generated by PCPartPicker 2022-08-23 11:36 EDT-0400

For work, I have to take an excel document of about 375 items and match up what zeros out. Is there an easy way using a pivot table or similar excel hack to expedite this process? Below is a list of sample numbers from this spreadsheet. Also, is there a way to find similarities in another line (in this case, invoice #) and match those up as well? I am using Excel Version 2111. 256.64 944.57- 994.57 8,236.98- 155.00 163.82 276.76- 174.66 1,583.83- 25.81 19.35 17.74 130.00- 27.42 8.06 19.35

I have hundreds of cells within Microsoft Office Excel (365 version) that are in the wrong currency. For example, cell A1 might have '$350', cell A2 might have '$440' etc etc. I need to highlight them all, then somehow convert them to the currency I want (£), however I'm not talking about exchange rates, I just mean change the dollar sign to the pound sign as they have been added to the sheet incorrectly. - E.g, change cell A1 from '$350' to '£350'. Any help?

Calling for an Excel Pro! I've created a location plan for the warehouse at work and now want to list all the location names in column A on a master sheet. Each section of the warehouse has it's own sheet and laid out as follows. How can I consolidate all the populated cells in the seperate sheets into a single column list on the master sheet? Also whilst keeping track of changes made to the location plans?? There are merged cells to deal with as well. Any help is appreciated Thanks Antony

Afternoon all, I've got a 1114 page PDF that is a mixture of parts diagrams and text. I'm trying to extract the information but when I try and import the data through excel it kills my ram 32GB DDR4 3200mhz. Is there a way to discard the pages with pictures on without going through them one by one? Or is there a program I can use that is better than importing from excel? TIA

I want to choose laptop which would be best for working with excel files. As I know generally some excel functions only use 1 cpu core to calculate so I think newer gen CPU would be better option here. I know that newer 12Gen CPU has more power in singe threaded workloads, when it comes to multi-threaded - it has 2 Performance-cores and 4 Efficient-cores and 8 threads. while 1135G7 has 4 standard cores and 8 threads, so which one do you think will do better when working with excel files? Simultaneous Excel failes are like 2-3, with not so big formulas in it. Should I choose 1215U over 1135G7? Thanks

I've watched many of the LTT videos, and as much as I enjoy watching the videos about gaming computers (I still don't understand threads, or cores or anything), I haven't seen a video about how to build a computer for regular everyday business activities for people such as myself (Especially with a lot of people that are having to work from home now). The only thing I know about computers is that they turn on and magic happens. I'm not a gamer, just a project manager. 98% of my day is excel, and I have found that I am going to need 4 monitors (I'm currently using 3). The spreadsheet that I formatted uses 3 separate excel files. With that being said, I need some advice on what I should look for in a computer. I'm replacing my laptop and docking station for a desktop. I do have one in mind, but I'm always welcome to opinions and advice from people who know a lot more than me about computers and tech. Many thanks in advance.

I am considering building a computer for work. I've never built one before, and I'm excited to do it. I am looking for any help, advice, suggestions or anything. Since computers aren't exactly my forte, I am here seeking advice and suggestions! What I do: I am basically a project manager at this point. I am working to open a music venue, and I live out of excel documents. The current excel monster that I formatted uses 3 separate files to do all of my calculations. At full load, I have between 5 & 7 documents open, youtube streaming, and another internet window for research. To be fully productive, I will need to have 4 monitors (5 would actually be nice, but I can utilize my laptop for the fifth), and a system that will be able to keep up with my daily workload (I put in about 10 - 15 hours a day average). I am trying to keep this to the lowest amount possible, but I also want to be able to upgrade the system later on if I need to. Stay safe, and thanks in advance.

Hello guys, Need your help with excel. Couldn't find out how to do next function, I want to move 5 characters from left side to the right side. Here is an example what I want to get. I have searched for some formulas like " =RIGHT(A2,LEN(A2)-FIND(" ",A2))&" "&LEFT(A2,FIND(" ",A2)-1) " But cannot get result. ADJR_Achkva from this I want to get > Achkhva_ADJR ADJR_Keda_HOC from this I want to get > Keda_HOC_ADJR ADJR_Khelvachauri_TV from this I want to get > Khelvachauri_TV_ADJR BATM_Batumi_Circus from this I want to get > Batumi_Circus_BATM IMRT_Chiatura_TV from this I want to get > Chiatura_TV_IMRT I want this solution cause I have 1000+ results like this. Thank you in advance.

So as the title reads, I need to work with 25+ instances of excel with tons of formulas and data in each instance. I have a powerful setup with an AMD 3970x Threadripper, 80GB+ of TridentZ RAM, Samsung EVO SSD, etc. But even with this setup it just cant process everything quickly. Now here is also something worth mentioning...I have assigned via python script each instance of excel to a different processing core on my CPU (32 cores), but still no luck, its agonizingly slow. Oddly the CPU is not even above 15% utility when calculating. So I dont quite get how it can be slow but not using all the CPU power or even close to max. I'm curious where the bottleneck is. Its also not the memory which is below 10GB utility. Anyone have any suggestions on how to make this work? Is there some setting, code, hardware set up that could get this running? Thanks in advance.

Can anyone help with excel the cell block I want certain cell block smaller, but not all the cell block smaller. What I am trying to do is make cell beneath "Learning about words" smaller so that I can make it fit into a page and make the text bigger when it is printed out. I try it extracting to word and it just more of a hassle to deal with the cell problem. Does anyone know how to fix this problem? I want a fully fledged no white spot beside the top right side. Conversion Table.xlsx

I have a custom library in my C# program which will open a custom file dialog to a custom location, and all I need to do is call it to a button, but every time I try this, it says that there is an issue with the 'Application.Run(new Form1());' saying an attempt was made with an incorrect format. Is this a case of me placing the code in the button rather than the openFileDialog code area? Whenever I try to call a normal fileDialog, it runs the default windows version. Here is my code: public partial class Form1 : Form { ALCGalleryLib.ALCGallery theGallery; ALCGalleryLib.ALCGalleryFile aFile; string tempFile; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { } private void showOpenDialog_FileOk(object sender, CancelEventArgs e) { theGallery = new ALCGalleryLib.ALCGallery(); // this will create a new gallery object and connect to the details it already knows about (it gets them from the registry) aFile = theGallery.showOpenDialog("All Files,*.*|Excel Workbooks,*.xls?"); // this call will show the gallery dialog and allow you to pick a file. it will get returned in the aFile object (or null if nothing selected) if (aFile != null) { tempFile = aFile.saveToDisk(); // save the aFile object to disk as you will not really be able to do anything with it, and anyway, you probably do not need to do anything else with this object. this will return a temporary filename // or you can choose where is gets saved with: // tempFile=aFile.saveToDisk("some filename.xlsx"); // or assign your filename to tempFile and then... // aFile.saveToDisk(tempFile); // either of the above calls will save the file from the gallery to disk and return the filename in tempFile } else { // nothing was selected } } private void openFile_Click(object sender, EventArgs e) { theGallery.showOpenDialog("All Files,*.*|Excel Workbooks,*.xls?"); } }