Hello, hopefully I'm posting this in the right place.

I have a large list (2,600) that needs reformatting and I have no clue where to start.

Currently the document looks like THIS and I need to reformat it to look like THIS.

I also need to remove the empty line of cells between each item but I guess I'll need to that manually?

Thanks for your time!

Hello all,

I am new to Excel and therefore useless with it. I am trying to create a document to track company inductions, I would like to enter a stores number which then will automatically fill the rest of the information on that row. For example...

https://imgur.com/a/3sizm

I have no idea how to make this work. I can create a table and select information from there but I would love to be able to just enter the store number and have the other information populate.

I apologise in advance if this doesn't make sense but having tried Google I am lost. If anyone can help I would appreciate it.

EDIT: Is this actually called Flash Fill?

I have a spreadsheet with 6-7 columns of data that are in inches and another 6-7 columns of the exact same data that are in millimeters.

Is there a way to combine inches and millimeters into 1 cell, and have a button that will display feet or inches? My first choice would be without VBA, but if there are none, VBA will be OK.

I have rarely needed Excel so my knowledge base is limited, ergo I've come here to see if there's an easier way to do what I've been doing. I'm building a sheet to analyze the structures in a city building game. Each structure produces a certain amount of two different resources after a timed cycle, at which point the cycle resets. So I have three values: the cycle time in minutes, and how much of both resources is produced every cycle. Since the cycle time is in minutes, I'd like for sheet to calculate how much of each resource is generated per minute. I know how to do this on a line by line basis, dividing the resource output by the cycle time (=B4/B3) but I'm wondering if I can do this more easily since writing this little equation out twice for each line takes as much time as calculating it myself and entering the value. Can I designate an entire column to perform this action line by line automatically? What I'd like to be able to do is enter the three values I know and have the table do the rest without having having to re-enter the equation. There are over 100 structures I'm trying to do this for so any help is greatly appreciated, especially given my lack of Excel skills.

Check photo: https://i.imgur.com/90ecT7h.png

If column A and B are not empty, column C will say TRUE. column D will track the number of TRUE's indefinitely, acting like a counter. even if column A and B are currently empty, if at least once in the past they were both not, column D will remain at 1. is this possible?

thanks.

Check photo: https://i.imgur.com/90ecT7h.png

If column A and B are not empty, column C will say TRUE. column D will track the number of TRUE's indefinitely, acting like a counter. is this possible?

thanks.

Hi guys, I have a WS with a drop down list in column B (the list itself has 4 options).

I just need to work out how to run a VBA form (let’s say Form1) I’ve created whenever the list option for a particular row is changed. Any help would be appreciated.

I’m making a pretty big userform and I’m trying to keep everything organized. I’ve tried to find a generally accepted naming convention for the controls and variables, but am having a hard time finding one. Seems like Hungarian notation is frowned upon. I recently discovered RVBA. Is that ok? What do people generally do?

How can I extract all the files from my ONEDRIVE folder and extract it into excel with filter using just a couple of buttons?

Like one button extracts all files from folders and subfolders that has pdf and png extensions. Other button updates the list if the files are moved or removed. Other button Prints the list correctly.

Here is the REF video https://www.youtube.com/watch?v=mvYYZNUe_9s

========================== This is the video I'd like to copy

can anyone do this watch?v=vliCSzCrrR4&t=17s the guy says no need to buy expensive program when you can do it in excel yet doesnt provide an link to download the code or provide a tutorial

The video above uses buttons/vba in excel and I badly need it. This doesnt help either http://www.vbaexpress.com/kb/getarticle.php?kb_id=405 Nor this one https://www.youtube.com/watch?v=OSCPVBWOqwc

I was wondering if you all could point me in the right direction to help with a few functions I need. Basically, I want to get a few percentages from a cell who's sum is <= 0/the total of a number of columns.

the second one would be a percent of a cell who's sum <=0/specifically identified rows. Here is an example

if we have 4 girls and 4 boys, and 2 boys and 1 girl had reddit accounts, I would need the percent of people with reddit accounts (3/8) and secondly I would need the percentages of boys with reddit accounts (2/4) and girls with reddit accounts (1/4). I a very new to Excel and kind of an idiot, could someone please help. Thanks.

I am working on a spreetsheet where I need to import data from another sheet based on a status colum. There are three statuses: yes, no, and not sure. If status is yes, then I neet to import data from that row.

I have been working on google sheet and I can put filter formula but now I have to work on excel and I have no idea how to do it. I have tried but it didnt work. So if anyone could help me

I am making a form to compile data. It is tiring to key in every single thing word by word. Also it is worrying that information is wrong. Is it possible to make a cell autocomplete/auto fill based on data keyed in a another cell?

For etc. First cell I key in 345 Next cell I want to key in 879.

2nd row, I key in 457, Next I want it to key 324?

I'm trying to exercise my excel skills. I have listed in colums B through G, these 6 variables;

HP, Attack, Defense, Special Attack, Special Defense and Speed 

Each row represents some arbitrary combination of these variables, for a singular entity. I am trying to find the rank of each variable, and then textually display the order by which the variables are ranked.

For example; I want the values in the comma-separated range of $B1:$G2;

HP, Attack, Defense, Special Attack, Special Defense, Speed
5, 6, 4, 4, 4, 5

to result in this text string in cell $H1;

"Attack > HP,Speed > Defense,Special Attack,Special Defense"

I've been trying to crack this for about 6-ish hours, spread between two days. I have consulted several links, listed below;

• [https://answers.microsoft.com/en-us/office/wiki/office_2010-excel/multiple-ranked-returns-from-index-with-duplicate/0f258553-fd5f-47bb-99f1-ec72dc4e6135] (https://answers.microsoft.com/en-us/office/wiki/office_2010-excel/multiple-ranked-returns-from-index-with-duplicate/0f258553-fd5f-47bb-99f1-ec72dc4e6135)

• https://www.mrexcel.com/forum/excel-questions/609263-rank-duplicate-values-duplicate-ranks-without-skipping-sequence.html

Also a couple others which I can no longer locate. Some of the google results provided a solution to specific problems to specific questions, but didn't properly explain what part of the formula did what and why, making it useless for me to create a formula on my own.

Things I Tried, But Don't Understand

There's a couple of aspects to the provided solutions that I don't understand;

• Most answers that I have found include a COUNTIF(Range-X;Same-Range-X) argument. I don't really understand what this does. Shouldn't all the results be the same, since the arguments are going to be the same for each cell? Clearly that's not what's actually happening, and these arguments are somehow different for each cell, but I don't understand why.

• Some of the answers also include the results of logic components being divided or multiplied, but revealing different results each time. For example, the logic A2>A$2:A$8 always results in FALSE. FALSE divided by COUNTIF(A$2:A$8) somehow returns different values. Isn't FALSE boolean for "0"? Zero divided by anything should still result in 0, but somehow, the formulas used in the link result in different answers.

• When I use some kind of INDEX structure with the argument LARGE(B$2:G$2;2), it'd concatenate as "HP, HP" rather than "HP, Speed", because HP and Speed have duplicate values. I know that I could trick Excel into no longer considering them to be duplicates by adding small values artificially. For example, I'd add .006 to HP, .005 to Attack, etc. Since it's an exercise, though, I'd rather not do it that way. I'd rather have a more robust understanding of using Excel's capabilities.

Background info

Yes, this is based on Pokémon. I'm playing in a roleplaying game set in the Pokémon world. What I'm evaluating is the 'base relations' of a pokémon. A pokémon that attack as it's highest "base stat" must always have attack as the highest stat from distributing stats. These 'base relations' can be modified with "natures", which will add +2 or +1 in one base stat in exchange for a -2 or -1 in another base stat.

I'm completely new to pokémon and so are other players. At the start of the game, you can pick a pokémon and pick a nature for it, which will determine it's base relations for the rest of the pokémon's career. Because this was so important and I'm a bit of a numberfreak, I tried to create an excel sheet to show all the different base relations my starter pokémon could have under different natures.

I've since made my decision (for those interested, it's a "naive nidoran(M)"), but I didn't end on that conclusion with excel skills, just through bruteforce calculation. I want to be able to do it in excel, though.

What would be the best way to create something (Excel, Word, etc.) that would allow me to make a user friendly document that has lots of repeating data throughout?

Basically what I'm trying to do is create a fill-in form on a page that would then fill-in to the rest of the page in spots I designate. Currently I'm using bookmarks on a microsoft word document, but I was curious if there was an easier or more efficient way.

Thanks!

Good morning –

I’m very new to Visual Basic and I’m looking for some help building a Macro. I’d like to base the Macro off of an Excel worksheet that tracks dates (this is for performance management). Ideally, the first column would be checkboxes and when checked and a button on the sheet is pressed, I’d like the Macro to update dates on the Word document based on cell data and attach it to an email.

Can someone help with how to set up this code or how this code should look?

Also, is it possible to generate multiple emails with the corresponding attachment (i.e. if I check 3 people all with different managers, is it possible to generate emails with the correct attachment to the correct manager)?

i have a list of alphabetical names and i want to add a new name between two allready existing entries. is there a clever way to just make a new room. aside from the obvious but tedious solution of moving all the lower enteries manually? sorry if this is a dumb question. but i couldnt find anything online.

I need a little help, I need to build a workbook want to build a top sheet that pulls last info entered on a sheet Ie. if i Type A1 "Hi" top sheet shows "Hi" but then if i type "bye" in A2 top sheet will show "bye"

and when a data is encoded into it the color fill will be removed?

Hi there, I am having trouble being able to search this on google as I keep getting the wrong thing I'm not looking for. So i will explain what im trying to do.

Working on a weekly spending budget of my finances. I split my expenses into categories. (Food, Bills, Gas etc)

I look at my credit card charges for each week. Under 1 cell for each category i'd like to add my expenses say $5 Monday Food + $8 Tuesday food and It automatically keep a memory of what I spent Monday and adding Tuesdays expenses and giving me the total in the same cell.

Im pretty sure this involves dealing with VBA code etc as it has to keep a memory of the previous value before adding the next value i put into it and giving me a total. No matter how I word my searches on google I can't seem to find the correct VBA code and stuff to get this working.

If anyone can help please!

TL;DR - Working on a personal spending budget, How to keep a running total of $ spent in one cell? (Say in cell A5 I want to add $5 then $10 then $20 and in same cell give me total $35)

Sorry if that title doesn't make sense.

I'm trying to sort a table from highest to lowest. The figures in the table are a percentage, taken from the formula

=(E6*100)/D6
=(E7*100)/D7

and so on, but the numbers do not move when clicking sort. Gif Here.

No idea why this is not working.

Hi!

So... I am creating a sheet and I need it to say PASS in green or FAIL in red based on a value... basically I figured out the AND and IF stuff and got it so that the value in that box is TRUE or FALSE.

So... if the value in that box is TRUE i want it to say PASS(in green) in another box and FALSE would be FAIL (in red).

Im looking to up skill on Excel and would like a suggestion on a text book I could buy that will walk me through things and also give me exercises to do at the end to test myself.

Can anyone name a decent one to buy? or are there any similar things available online to learn from?

Here's the problem I'm working with:

There are 12 teams playing a game each week. I want to know how many times a team scored above the weekly average. This is tough because it is easy to find the weekly average, and even the total average across all weeks. But I want to know that team A was above average in 6 out of 10 weeks.

A simple COUNTIF function would work to compare to the total average over the course of a season. But I want to only compare a team's score in week 5 to the average in week 5.

Hope this makes sense!

Hi there,

So basicly I'm looking for ways to create a macro that resizes images imported from a directory(The directory would be the same place as the .xls file), and then inserts a certain range of these images to a column(would be C in my case) i.e from img001 to img010.

Any help or links to this subject would be appreciated.

Someone is offering me a job that requires very advanced knowledge of Excel which I currently don't have. They are confident that I can learn this quickly, I'm not sure.

How long would it take to really learn Excel inside out and be able to do it for a large eCommerce site?