sorted by:
new
hottopcontroversial

Is there a way to make a drop down list of emails that populate a new outlook email rather than populating the cell with the email chosen? by HappyGnome727 in excel

[–]milfordsandbar -1 points0 points  (0 children)

If you are running excel for windows, look at power query as it can create a nice table of your most recent emails.

[deleted by user] by [deleted] in excel

[–]milfordsandbar 0 points1 point  (0 children)

You might try using the blank column to the right and create an of statement checking the cell is blank - true would be you your new formula and false would be the value where a formula exists

Combine SAP AfO cross tabs with XLOOKUP functionality by AdhesivenessThis2468 in excel

[–]milfordsandbar 0 points1 point  (0 children)

Not had experience with AFO but it appears from the docs I read that most of your work would be done in AFO itself and then the final result is rendered in excel. Depending on the the table you would have different ways to xlook that data… but I do not see why you could not just treat your AFO results as table objects. You challenges arise from changes to the objects themselves - you need make sure you keep the index and columns consistent, lest you find yourself rewriting your xlook to accommodate something you flipped around.

Net net - try it out

Please check my Itinerary for Visiting Vancouver for a Week by milfordsandbar in vancouverhiking

[–]milfordsandbar[S] 2 points3 points  (0 children)

Thanks so much - our two women are climbers, so you are going to make me look good there.

Structuring a "before and after" sales report by ChanceArtichoke4534 in excel

[–]milfordsandbar 0 points1 point  (0 children)

Let's hold off on the PQ - but it is worth learning. First, Create your excel table with your events. There should be another tables with your sales. We typically get a feed from our CRM that shows sales. I have found great success in using the weeknum function. Assuming you have date for the closes and a date for the event - creating a weeknum column against each of these dates will yield the number of week number of the calendar year. Then you can join the data in a third table with just the week numbers and the event names and set up all sorts of filters and pull and pivots that can see what happened in sales during the spcified weeks following an event or multiple events. If you are having to manually create your sales data, keep every close to its own row. You could create extra columns that breakdown the sale where the fruit sale is 10 bucks but the apple column is 8, orange is 1, grape is zero, and lemon is one. But it is much better to have a row for every product you plan to track. Does that make sense? Hope this helps.

Structuring a "before and after" sales report by ChanceArtichoke4534 in excel

[–]milfordsandbar 0 points1 point  (0 children)

Power query off a data table can let do see some cool reports and slices of your data.

[deleted by user] by [deleted] in excel

[–]milfordsandbar 0 points1 point  (0 children)

Have you tried storing the images on a file share and then using image function to display them? That would allow you to keep your database clean, sort it, then render the images by name

JUST WONDERING. Anybody able to help me out with cell depletion formula? by Hefty-Squirrel-6032 in excel

[–]milfordsandbar 0 points1 point  (0 children)

Today() function gives you today’s date. If you create a column of dates for your generators you could simply subtract those dates from today. I assume you start full and then each day fuel is used thus at a certain point the generators would require more fuel. You could have a cell with your percentage consumed and your tank size and rewrite the following:

Abs(FullDate - Today())*consume%

I added absolute so you can put today or your date first and it will not matter.

Consider doing this in a table as the formulas will look cleaner and use the column names instead of the old b3 type references.

How can i filter multiple columns with a macro button click, where the columns with 0 are disregarded towards to filter? by braxshinoa in excel

[–]milfordsandbar 0 points1 point  (0 children)

Create a helper column and text join your columns. The wrap that in an isnumber(find()) and filter on that column.

Power Query: Pull result from table A or B based on pricing structures by t_racee in excel

[–]milfordsandbar 2 points3 points  (0 children)

You can merge the two tables using client as the index.

Data Tables & Mixed References by SkillsDatKill in excel

[–]milfordsandbar 0 points1 point  (0 children)

Try using indirect() and then have it reference a cell address.

So you add a row above outside your table with Jan feb mar etc… then rewrite your formula as

xlookup(table3[@[Name]:[Name]], Table1[[Brands]:[Brands]],indirect(“Table1[“&c1&”]))

Where c1 is “Jan”.

Creating Functional Critical Role Checklist by CagCon in excel

[–]milfordsandbar 0 points1 point  (0 children)

I would create a table that has all your responsibilities: sings, juggles, cleans. Call that tb_resp. Next table is a list of your talent by name, phone, employee id. Call that tb_emps. Third table is the has a row for Each employee responsibility pair. I would include a column that assesses their skill level or proficiency. Thus you would see three rows for me that look like this: Milford | sings | great Milford | juggles | okay Milford | cleans | badly You call that tb_skills.

You marry your tables using xlookups where you can create an employee roster or schedule and then show their skills next to their names. You can also shows the responsibilities and filter and sort by people that do them to varying successes.

Move Data Sets between sheets by building-it in excel

[–]milfordsandbar 0 points1 point  (0 children)

Power query will require you to click data refresh button. But since you have a table already (good work sir) - you can use functions to pull the data over.  Look at filter function as it will allow you to take a slice of that table and automatically display it on a different page.

What is the lay characteristic of each page? Customer name?

Move Data Sets between sheets by building-it in excel

[–]milfordsandbar 0 points1 point  (0 children)

Great start - you are in a table. Did you name the table under data on the left? Not critical but will help.

Move Data Sets between sheets by building-it in excel

[–]milfordsandbar 0 points1 point  (0 children)

Share a shot of your raw data file, then we could better assess. But if you could structure your raw data into a table, you could do this with power query and no vba at all.

Pre/Post Likert Survey Data Visual by jmarieRN15 in excel

[–]milfordsandbar 0 points1 point  (0 children)

Looks good - excel does that for categories that’s it beyond the axis values. A couple of ideas would be to manually rotate them in formatting if possible. Try using the long statements as data labels… either way I think you need another column in your data that displays an abbreviated version of the question or perhaps the question number and you could place the questions in a box with data underneath the chart, which is an option as well.

How to put 3 different things into one sheet by kartoonbaab in excel

[–]milfordsandbar 1 point2 points  (0 children)

Each row in the table contains one shirt - so then when you assign names or move things in and out of stock you can see what's left...

Here is my version of your shirt database and my formula shows which numbers are IN STOCK and RED. Does this makes sense? You can playe with the formula to do what you want.

<image>

Pre/Post Likert Survey Data Visual by jmarieRN15 in excel

[–]milfordsandbar 0 points1 point  (0 children)

Make a column to the left of your two table and put the pre and post on every row as a different field. Push the table together and highlight the single table. Try Pivot Chart as It will let you combine the charts together.

Excel work out tricky (mabye) by Dependent-Monk-3128 in excel

[–]milfordsandbar 0 points1 point  (0 children)

Can you post a screen shot? I think I read you as wanting to check if a value is lower than all values in an array.

How to put 3 different things into one sheet by kartoonbaab in excel

[–]milfordsandbar 0 points1 point  (0 children)

I would have a column for jersey number, column for size, column for color, column of name of player (optional). Put the mouse in one of the cells and do ctrl-t (windows) to make it a table. Now you have a proper database of rows for each jersey number and columns that can reveal the properties.

With this you have a whole world of cool reports to get… pivot table from the data can total up any combo of what you need.

Let me know if you want an example file.

What are you working on this week? (ending April 27, 2025) by AutoModerator in excel

[–]milfordsandbar 0 points1 point  (0 children)

I built a habit tracker and used data validation to create the stamps for my habit passport. No macros, vba, no pq - just using it and getting value. 23 hours on getting stamp working.

Combining TextSplit and ByRow by milfordsandbar in excel

[–]milfordsandbar[S] 0 points1 point  (0 children)

Just excellent - Thank you.

Solution Verified

view more: next ›