wondering

If I currently have detailed property list that shows address, square footage, location, and other details, how can I extract the data from each property into its own singular property info? I have used index with match to do so but I was wondering if there was a better way. Any tips? Thanks in...

Hi team, I was wondering if someone can help me with the following: I have the below report that I receive (thousands of rows). I want to pull out certain countries into another tab that are relevant to me. I wanted to use index/match to pull this information, however I am not sure how to do...

Hello All, It's been a while since I've posted and was wondering if anyone could solve my problem please? Here is my named range with the dropdown in cell K3 I then have a dependant list in L3 Here is the formula I have for the dependant list Everything is working well. However, I...

Can someone explain how I can access a CSV via inputs and find matching values from 1 column. Then to output these as a CSV. The file is to large to open in Excel and I was wondering if anyone could help me with some vba to do this

I have a complex workbook with a lot of macros. Yesterday, I noticed the file size shrank by 15% when I switched from .XLSM to .XLSB. All the macros seem to work - though command buttons seem to flash strangely at times. The performance speed is about the same (less volatility in macro speed...

So I am using a third party add on for excel and it messing with my setting. I have set up a macro button to do this to change the R1C1 Sub r1c1() Application.ReferenceStyle = xlA1 End Sub But I am also wondering if there is a way to toggle the "Show paste option when content is pasted"...

Hi everyone, hopefully sile question but I've noticed when i get hepl some times i get this "Eviron("USERPROFILE")" and sometimes "Environ$("UserProfile")" is there a difference? why the "$" and the capitals? just wondering if one is better Thanks Tony

Hi all, Wondering if there is a standard/recommended approach to naming - Ranges - Tables - Graphs - Worksheets - Workbooks etc I've seen table with 'f' and 'dim' before the table name. Just looking for the better way to go about it. Thank you

Hi! I am trying to create a sales form for my four-man team. I have codes for saving the file as PDF, using a filename in a designated cell, but it only works on my computer. I was wondering if there is a way to use the same file and just save it to their desktops. Thank you!

Hi, I was just wondering, is there a way of once the formula has worked to just keep that original value there? For example, i'm using a VLOOKUP to get my results which work perfectly. Once i get that result i dont want it to ever change as what would happen is when i update my spreadsheet...

Hi All, I am wondering if you could help me? I have a table (TBLSJ) which is looking at athlete Jumps a bit like this: <colgroup><col><col><col><col><col></colgroup><tbody> Name Date Jump Type Male/Female Player 1 11/03/2018 47 SJ M Player 2 01/04/2018 54 R M Player 1 03/04/2018 57...

Hello i was wondering if i place a Y in A1 can it = 1 in A2 or if i put a Y in A1 can that = 1 please help

Hi, I have a worksheet created whereby I want to find the best spacing and associated post type that results in minimal cost that Zex>Zex Min. I haven't had any luck and was wondering if one of you legends could help. I've tried running solver as per the picture below It claims it has run...

https://1drv.ms/x/s!ArHhL08110anmBjx0Xyj3khzBu0S Here is a link to the data set, sheets1:5 have random numbers in A1:N10 On sheet6 it uses =SMALL(Sheet1:Sheet5!$A$1:$N$10,ROWS($1:1)) to =SMALL(Sheet1:Sheet5!$A$1:$N$10,ROWS($1:20)) to get the 20 smallest numbers in the range, wondering anyone...

Hi, I am curious whether the MS MOS certification is worth exploring. I am an accountant that does a lot of work with Excel and is in particular branching into PowerBI etc. I have not had any formal training per se and was wondering if it would be worth pursuing training in either the MOS and...

Hi My original formula in column H =SUMIFS($B$2:$B$10000,$A$2:$A$10000,G2,$C$2:$C$10000,H$1) I got it faster by editing as below: =IF(G2=0,0,SUMIFS($B$2:$B$10000,$A$2:$A$10000,G2,$C$2:$C$10000,H$1)) Wondering if adding a COUNTIF check would make any difference? Like...

Hi all, Hope your Friday is going well. I am currently working on a dashboard for KPI's and i have been making some pie charts. I have displayed the pie charts percentage on each section of the pie and I was wondering if there is a way to hide the zero percentages. Thank you in advance, Mark :)

Guys, for fun, I'm trying to learn something new. I was wondering if it would be possible to have a report like the one on the picture. In columns, you would have the vendor's name and in rows, the KPI associated. The information would be pulled from the sheets which would have the vendor's...

This is so far above my head I am wondering if you guys can help me! Columns A-D are what I want to refer to. DOG/MOM/DAD all have the same date ranges by week. Each combination of DOG/MOM/DAD and the dates of the week on or between column B & C receive a unique code which is in Column D. What...

I was wondering if a pdf is actually stored in excel when you insert it as an object or is just a link to file location. Im wondering if I insert it as an object then email the excel workbook to someone will it actually open the pdf.