Ray Bailey
New Member
- Joined
- Nov 12, 2015
- Messages
- 34
Hi All,
I have a number of files, which I've converted to tables, that have same headings but in different sequence dependant on usage. I also have a number bespoke functions.
Is there anyway that I can get a function to read the contents of a table.
Example
File A
Seems simple so far but another file could have 30 columns with Status, Start Date & End Date anywhere.
In z_Function I want to put
If [@[Status]] = "Started" Then
z_Function = "Started on " & [@[Start Date]]
Else
z_Function = "Ended on " & [@[End Date]]
End If
It's a bit more complex than that but hopefully will give an idea of what I need.
Thanks In Advance
I have a number of files, which I've converted to tables, that have same headings but in different sequence dependant on usage. I also have a number bespoke functions.
Is there anyway that I can get a function to read the contents of a table.
Example
File A
Status | Start Date | End Date | Current Position |
Started | 01-Jun-20 | =z_Function() | |
Ended | 02-Jun-20 | 19-Jun-20 | =z_Function() |
Seems simple so far but another file could have 30 columns with Status, Start Date & End Date anywhere.
In z_Function I want to put
If [@[Status]] = "Started" Then
z_Function = "Started on " & [@[Start Date]]
Else
z_Function = "Ended on " & [@[End Date]]
End If
It's a bit more complex than that but hopefully will give an idea of what I need.
Thanks In Advance