post

<tbody> Date Department POST Name Email Contact City Remarks Admin Clerk abc abc@abc.com 04334325 Dubai Free for job Sales BDE xyz xyz@dfdas.com 89478943 Al Ain on Job </tbody> I got this data sheet, on the next sheet...

Hi gang, New here.....do I have to post a certain number of times before I'm allowed to attach something? If not, how do I attach file to a post? Thanks, PC

Hi All, I have spent quite some time searching for a solution to this problem without success so thought I would post my first post. I would like to make a macro that allows the user to input a cell value to determine the last cell in a range (A1:x). The range always starts at A1. Then the...

Is it within rules to refer to my post that hasn't had any replies other than my own?

Many thanks for taking the time to stop by and look at this. Is there an easier way to do this or can this be fixed? Part of a longer formula is not responding as I expected it to. I suspect it's my expectations that are wrong. In essence, what I need to achieve is to identify a "Zone"...

I have a table of data. For ease, say there are four columns, titled division (e.g. Africa, Europe), country, region (north/south), and city. The data is all sorted from column to column. I would like, in each column, to have any of the same batch of data one colour and the next batch a...

Hello Friends, can anyone please tell me how to post my worksheet into the thread which will help me to post a layout of my data in a much better way. Regards,

Hello, I have tried with no success yet to add an attachment to my post for clarification. Can someone please assist? Thank you

Hi, I created a set of macros that I need to be able to call whatever the workbook is openned. For example: Public Sub ResetFullLayout() '**---------------------------------------------------- '** '** Purpose: Reset layout to view all columns and all data '** '** Input: none '** '**...

Hi All, I have searched the forum and found some US postcode versions, but i am looking for a post code calculator in miles for the UK by road. Does one exist for mileage by road. I have seen some mention API ( i am clueless about), so am looking for a legal version as i saw it mentioned...

Hi all, I am looking to do a mail shot from a publication but need some assistance in sorting the data from a pdf. The data comes in the following format: OK1234567 R The food company Ltd Director(s) Mr Joe Blogs, Mrs Joe Blogs Unt A, Some Road, Some town, Some county, Some post code...

Example is below. Which was pasted from a word doc copy. If I post the copied text in gmail, it does the separation! But if I try to post the list in excel, it puts all the content into one cell. Maybe there is some prepasting setup I can do in excel before pasting that would do the...

Hello! I was attempting to create a post and my browser crashed. Looks like the text and part of the code posted anyway. How can I delete it? I have commented that it was an error so any readers will know to ignore. Thanks in advance Robyn

From a previous post I have been using the function at the bottom of the post. I now wish to use the aggregate function again to find the Max value from a different range of cells but still based on only those records that are in a particular year. I have tried modifying the function as below to...

Any help in this would be greatly appreciated, I am setting up an Overtime Equalization Spread sheet that tracks numerous pieces of data throughout the fiscal year. I. E. If employee worked overtime , if they refused overtime, what shift I was for ( Day Afternoon or Nights) and the reason...

I'm trying to learn how to post code etc before I use this site and not having any luck. I tried to download MREXCEL HTML Maker but do not have Addin folder? (that's a question i don't know how to answer). Testing post of code below seems ok but would like to show output from excel table. Any...

Hi, I have a population of businesses whose post code I know. What I want is an Excel calculation that will show me the number of other businesses within say 40 square miles of their Post Code? I can get the post codes and convert them to longitude and lattitude coordinates but I dont know how...

Evening all, I am looking for something where i can enter a customers post code & the code would then looked at a list of post codes in a database of mine & select the closest to post code supplied. Does any member use such an item ? Many thanks

Hello! So, I have a spreadsheet with several columns that contain various information. I am trying to work out a formula that will check if a flag is set in two separate columns, then depending on a range of values in another column, determine a calculation for a final result. So, in normal...

I went through some Index and Sumproduct solutions with AhoyNC in this thread: https://www.mrexcel.com/forum/excel-questions/1060891-using-vlookup-check-date-against-date-range-return-value-2.html#post5095694 But ultimately my data table is too big (last post in thread has a URL) and...