easily

How to open a xla file easily?

Since i'm new to excel I'm not that sure if there is any type of formula(s) that would be able to easily calculate costs basis the below parameters. Calculating the "units" isnt the hard part for me, i've got that done already. It's finding a formula to calculate the costs once I have the...

hi all, if i want to enter a time with format([$-en-US,1]hh:mm) in A1, how can i easily track in column B, if time is larger than A1, bold/color the cell automatically? thanks

Hello Message Board: I am trying to convert a small data set from text to number ( AMOUNT Column) . I have tried several methods including text to columns , Fomulas like =VALUE(TRIM(a3)), Trim, etc and I cannot get rid of the trailing spaces to the right. I need a formula solution for this. I...

Hello, I am putting together an Invoice template for myself and I would like to add a drop down box with a calendar so that I can add dates easily. How do I do this? I have excel 2019. I tried looking it up but the things i found were for older versions of excel. Thank you very much for your help

Reference :Help in Easily Downloading new images into Power Bi for chartinfo graphs or find images that can be easily downloading to use in Power Bi Hi there I a new to Power Bi ... so be gentle with me :) I have download images in my picture but when I downloadthem into power bi when I...

Hello I am trying to set up a staff spreadsheet so I can track when the qualifications are due. I already have a spreadsheet with the dates the staff did the training an would like it to change colour so I can easily see when they are due this year. Could someone help with this please?

Hello How can I easily blend text and formulas with FormulaR1C1? Ideally I don't want to have to double quote everything or escape numerous characters etc. Is there a neat way? Thanks

​Hi, i would like to combine SUMIF with SMALL but has some problems doing so: I have a table where Week/Year is stored and now i need to create a Top 10 of the worst results for each week. I can easily do it with the whole data set by using =SMALL(Tabel1[Percentage];Oversigt_!A3), but i can...

Need to find row and column pivottable ends in VBA. Is this easily retrivable in VBA?

Hi All, very very new to power Bi. Can you guys help me from where I can learn easily power bi..

Hi All, I have a report which shows clock in and out times for staff members. This literally shows every time they clock in/out during the day, but what I want to do is easily find just the first and last clock in/out. The below link shows an example of the data...

Hi guys, I'm attempting to build a master sheet that contains employee information. I want only the master sheet to be editable. I have roughly 500 employees listed, along with 10 other relevant columns. I want to break down the next sub sheets into office positions. I have 8 different...

Hello, I have VBA Userform that allows a user to enter a whole bunch of information, maps that information to a spreadsheet and then I get to dig through the collective data. Awesome. Whatever. My problem is that this Userform doesn't "play well" with other workbooks being open...

Hello ALL, I have a workbook with 15 sheets. I have copied the sheets from the old to the new workbook, but the codes on each sheet did not go with the copy. How can I easily copy all sheets with their codes to the new workbook? Thanks for any help

Hi everyone, The following relates to the website https://rid.tcdc.govt.nz/ In the past I have had help from this forum in getting data from here using vba. Unfortunately this site has been rewritten and now I am stumped again. For example, if I wanted to know the Capital Value of the...

Here's a demonstration of what I want to achieve, but in a much larger scale: https://imgur.com/a/8FZvA So in the A column there's numbers which can be anything really and I need to list them in C column. I can easily do it manually on an example that small, but I have a sheet with ~30 different...